Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
cfqueryparam syntax issue
the data type is CD_SQL_DATE. Though with further research it appears that the probelm I'm having is inherrant to access & passing date strings. the base application I am using is Gridmonger 3.20. Apparently in 3.30 that was one of the big fixes was to re-write the calls to eliminate the... -
cfqueryparam syntax issue
This should be a string "2011-01-05". The form variable @ (FormFeilds,variables.LoopCounter) is a date string determined using a callender lookup. -- The history of the issue is that I used to use the statement <cfqueryparam cfsqltype=#variables.SType#... -
cfqueryparam syntax issue
Problem occurred while parsing, "#DateFormat(#Evaluate(ListGetAt(FormFields,variables.LoopCounter))#,"yyyy-mm-dd" )#" OR, sometimes I get [2011-01-05] is not a number. with the expression <cfqueryparam cfsqltype=#variables.SType#... -
cfqueryparam syntax issue
I am using bluedragon.net 6.2. I am having problems with Gridmonger 3.20 what I want to do is pass a date (stored on form as string) into my acess database. Code - that is not working <cfqueryparam cfsqltype=#variables.SType#...
