Query Errors

[Vivid_Visuals]

Hello,

I changed hosting companies and now I'm having issues with query errors. I attached the code of the first one below.

Does anyone have any ideas?

Thanks

[Guest]

First off, did your new hosting company create your datasource for you? I imagine they did, but I ask because sometimes a hit counter is the first DB activity you'll see, and that can be related to the datasource being set up.

[Vivid_Visuals]

Hello, thanks for the reply!

I've really been having issues with this site. Anyway, no, my hosting comany didn't create it, I did, along with another programmer. We found the problem yesterday. The table name inside the database was called counter and for some reason my new host didn't like that. It must be the version of CF they are using. I got around it by changing the table name to hitcounter, but thanks for you help anyway.

We've managed to fix most of the errors now, but there are stll a few giving use trouble. Here's one more:

[Guest]

Knock down your UPDATE script to do one update at a time, when each works add another field in your update script. That's how I track down the problem child.

Also, take a look at cfqueryparam. It can really save you some headaches.

[paross1]

Perhaps the column named password is being treated like a reserved word (sometimes is).

Phil