I tagged three things that you might want to look into. The first thing that I would do is run these queries in an external analyzer or dump the contents of the recordset.
Also, make sure that you have the correct permissions to drop the procedures. If your script is picking up system...
First thing to check is how you're calling the scheduled task. Are you calling the copy of the page on the new server or on the old one.
Second thing to ask is have you run the page manually to verify that it's doing what it's supposed to. What it sounds like to me is that your page might...
Not sure what the equivalent is in ASP or PHP but using ColdFusion's CFHeader and CFContent tag you can reference to a .cfm page for downloading and then have the .CFM page literally push the file out as opposed to redirecting to it.
It's all in the headers and how the browser sees it...
According to Macromedia's site it is possible with some work:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18338
I don't know if that's something that Jodo would set up for you bu they'd definitely have to be involved.
Also, a quick search revealed this page...
I can't speak for Jodohost directly but if you're looking for the files it sounds like you already have a local copy of SQL Server running as well.
If that's the case it would be easier by far to use Enterprise Manager to connect to whichever mssql server you're using at Jodohost and use it...
When I write SQL I remember that it's an easy to read language. Your query says the following:
What you need it to say is:
That is written in SQL as:
SELECT Products.Name as ProdName, Categories.name as CatName
FROM products INNER JOIN categories ON
Products.CatID =...
IRCD is indeed an IRC daemon. - a server that allows people to connect to it and chat. It also connects to other servers to provide users multiple points of access to a "chat network".
The only way you could fill his request would be with a VPS account since it is effectively a linux box...
Was there any follow-up on this issue? I'd really like to have something in the FAQ without having to pay a data-entry person for days on end to get a KB built.
I'm finally working my way around to getting HSphere set up so people can sign up for hosting and domains using my site and I'm running into an issue:
At http://jodohost.com/reseller/html/domain_registrar_manager.html I see where it says
# Log into your admin CP.
# Select Domain Registrar...
Nice design but there are a couple of areas that need to be addressed:
- the menu links on the top and bottom of the header are standard blue underlined.
- You have no way to click on a submit for the domain name search.
Without being able to see more indepth (all the links go to #)...
Since I'm not an ASP or .NET person I won't be able to lend a hand with the coding of the site. However if you need a CF resource once the site launches let me know.
You could simply do a ReplaceList(MyString, "<,>,&", "<,>,&") either on a usage by usage basis or actually throw it into a CFFunction so you can reuse the code whenever you need it.
Hatton
Well, for starters you need to shoot your graphics guy. When I clicked on the site the first thing I saw was the icon... looks like someone's wanting me to play hangman rather than look for prospective employees. Then I saw the logo. Personally it looks like a drunk teletubby stick figure...
I know I've been out of the loop for a while but I thought I saw the ability to creat a CF DSN when I was setting up my account list recently... where can I find this option on the menu?
Thanks!
Hatton