nope - not case sensitive.  i think i discovered its a CF thing.  apparently, CASE is not allowed in a query of query in Coldfusion.

bummer!

ok i think i can see what you are trying to do here but unfortunately i am still getting the same error when i run the query.

i tried adding the T.myTCount field...

hey thanks for the quick reply - i tried that and i keep getting the error : Column 'T.MyTCount' is invalid oin the select list because it is not contained...

interesting article - (i have only skimmed it so far but will read it in its entirety shortly)  looks like that answers some of my questions - thanks for the...

i know the advantage is that the performace is better but for queries that are often used but if i had a stored procedure on my SQL server for evey...

no i am not.  should i be?

ok so if my select query for the resulting page looked like this:

SELECT *

FROM tblName

ORDER BY Lname

what would my new query look like?  something like this?

SELECT @NewId = SCOPE_IDENTITY() ,*

FROM...

thank you for the reply!  so let me see if i have got it right -

you are saying that i should have a transform data task to get the...

nevermind - dumb question - just open it and go to file save as.  duh.

ok i kind of figured out the lookups. in the lookups tab i set my query to:

SELECT DR_NAME

FROM ...

ok i have looked around for info on DTS lookups and i dont completely understand them yet but i have read that they can slow things down a bit and...

that worked well for my MySQL database but now i am tryign to do the same thing on an SQL Server 2000 db and it does not like that format.

any...

someone on the macromedia forum suggested that i use this format:

Insert Into option1Values(ProdID, myValue)

VALUES

(1,'Red'),

(1,'Orange'),

(1,'Green')

and it seems to work.

no its nto a temp table it is goign right into the live db table.

and i am not sure if i can explicitly set the length of a CF variable...

#listlen(form.option1values, chr(13))#  returns the number of items in the list.

and in that line i amsaying that if the counter is less than the length of the list, then output the...