Image path doesn't come out of DB intermittently

[chrigil]

Can anyone offer a solution to a rather strange problem? We have a galleryTable in our database with various fields including imagePath, imageThumbPath, imageDesc, imageName etc. A few weeks ago we had a problem after converting from MySQL to SQL Server where some fields refused to come out of the database. imageName was retrievable as was imagePath but imageDesc and a couple of other fields wouldn't come out of the DB. We eventually solved this by changing the variable names in our ASP pages from something like:

imageDescription = recordSet("imageDesc")
to:
imageDesc1 = recordSet("imageDesc")

For no apparent reason this seemed to work.
Now however it has started happening again with the same table but different fields. We have tried changing the variable names but not suprisingly this hasn't worked.#

Any ideas what the problem might be? Is it due to the MySQL converion do you think?

Thanks in advance,

Chris

 

[chrigil]

Come on someone must have some idea as to the cause of this problem?



Thanks in advance,

Chris

 

[Corran007]

What data types are they?

do you have any problems manipulating or retreiving them in query analyzer?

 

[chrigil]

There dosn't seem to be a pattern with regards to the data types. Sometimes its 'int' other times its 'varchar' or 'text'.

I have no problem getting the desired results in the Query Analyser.

Strange eh?



Thanks in advance,

Chris