Hi John, That throws an error, (data type mismatch) which I catch with an exception page. This is working for my re-occuring single quote problem; I have in...
My point is - it's the same issue with the single quote as with the letter A. You are expecting a numeric value but the user can enter any value they wish....
Thanks much for taking the time to write a paragraph. I understand your point. I will forget about "fixing" url's - I'll relocate to a help/search page. Would...
I think that structKeyExists is more efficient than isDefined. <cfif structKeyExists(url, "article_id") and not isNumeric(url.article_id)> -hankcfman ...
That is perfect. You always want to think about how a malicious user could screw things up. There's a lot of attacks targeting ColdFusion sites trying SQL...
I like this discussion and it's making me rethink a few things. I also get a fair amount of errors logged because of the single quote. Because the string is...
The first place I would look is the code that generated the input field for "category". I would say the ' is coming from there and probably a typo in the...
Where do you start? I would start by not passing any url or hidden form variables and passing them through sessions variables. Then I would make sure that I...
Seems so simple, but this is not working: <CFQUERY Name="getmaxbid" Datasource="#application.dsn#" > Select max(bidamount) as maxbidamount, pagesubid from...
Try: Select max(bidamount) as maxbidamount, pagesubid from auction group by pagesubid having pagesubid = #pagesubid# ... -- John Bliss IT Professional ...
Sorry, but <CFQUERY Name="getmaxbid" Datasource="#application.dsn#" > Select max(bidamount) as maxbidamount, pagesubid from auction group by pagesubid having...
I would like to get some input on the effect of cfc files on server resources on a semi shared server, compared to using queries and such directly in the...
Hi All, I have an excel spreadsheet that lists details of apartment owners that I need to insert into my sql table if the unit_number is a numeric value the...
Hi John, The code below inserts blank values for #unit_number# when the value has a character at the front or the end of the number eg A541 or 543B When the ...
And now, you should change your database username/password, since it is out there for all to see... <cfquery name="Insert_ A_Property" datasource=" #ds#"...
The query looks fine, try outputing the value of "unit_number" before the query to see what it's being set to. Since you really should change your database...
In the applicatiion I'm building, I have three pages of forms. I want to dynamically create session values and store them to keep the form stuff together. ...
Hi, I have a lot of data that are comma separated and i want to enter them into a database such that each comma separated value is entered into a new row....
Hi all, I am looking for a Coldfusion job from 6 months.. could anybody pls.let me know of any Coldfusion Openings in and around CALIFORNIA. i have around 8...
I have a content management system that I am trying to enhance with the following functionality: The ability for a user to extend his/her login session if the...
I have to read tables from two different datasources, so I us QoQ My first query : <cfquery name="qry1" datasource="db1"> select table1.name, table1.phone, ...
You can query two different data sources within the same query and still use your left join (right join, inner join, etc). At work, we query Oracle and SQL...
Can you show me how to query two diffeent datasources within the same query ? I have never done that before, and since cfquery tag has only one datatsource,...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
