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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by NicoleN
-
Escaping single quotes in variables with variables
I'm using MS Access and ColdFusion 4.5, sad, I know. I will give Sylvano's suggestion a try after I get out of my morning meeting. Cheers, Nicole -
Escaping single quotes in variables with variables
Thanks, that enabled me to remove the single and double quotes all together (which I'll keep for now, as it has eliminated the errors I was getting), but how do I escape them so that they remain, but don't upset the SQL statement? I tried: <cfset formVar =... -
Escaping single quotes in variables with variables
I'm having trouble figuring out how to escape single quotes that my users may input. The variable in my SQL statement looks like this currently: SET PIR = '#evaluate("Form.PIR_#PIRID#")#' I've had to write it like this so that when the user is editing a record, they are able... -
Help with outputting from a query with multiple joins
After spending a while sorting out the SQL for my query, it seems to be working, and is pulling back the information I want. However, when I try to output the query into a table, I end up with duplicate information in the cells (where multiple entries are allowed for the same record). I've...
