Hello i am trying to have insert twice within the same cfquery but i dont know how to insert the scope identity of first into the second query. thanks <cfset...
I get javascript code off the net, and sometimes it is written for me, to incorporate into the cf applicaton. Sometimes, in the form statement, onClick...
I don't think it's question of the proper way . Either onClick or onSubmit could be appropriate for your application. You have the flexibility to use ...
Is anyone else having problems with dynamic drop-downs in the new Google Chrome browser? My query doesn't display in the the drop-down in this new browser....
I am trying to group my cfquery output by date however as the values the date column also include the time stamp this is causing a problem. Is there a way that...
Using CF8 and usableforms.js at http://www.quirksmode.org/dom/usableforms.html. The user will select one of the radio buttons to display the corresponding...
If the form field isn't selected, then the value will not be passed to the action page. You may need to setup a JavaScript to update a hidden form field to...
Coldfusion doesn't like anything that ends in "_Date" if I remember correctly. I would try setting that as PayDate. Only time you need to worry about filling...
That's what I'm looking at now, but I'm not a javascript person. Do you have an example? BTW, I'm using fusebox, so this form passes info to the fbx_switch...
I may have misread/misunderstood your question so I wanted to try again. ... In your post, you said "this is at the top of the form." Do you mean on the form...
Are you wanting to populate the hidden field with default text or dynamic text? - If default, just put the default text on the action page. - If dynamic...
I have a form for the user to select parameters from. There are radio buttons on that form <tr> <td class="formTitle" align="right">Select By:</td> <td...
Wow, FuseBox, talking about jumping into CF with both feet! OPTION A On your FORM page use: <cfset pay_date = "XXX"> Then on your action page, you can write: ...
Fusebox is much easier than understanding another developer's spaghetti code. As for option A, setting a variables scope variable on the form page won't do you...
Thank you, thank you! I ended up with the following: <cfif not StructKeyExists(attributes,"pay_date")> <cfset attributes.pay_date = "X"> </cfif> which does...
Sherry, Not being proficient with FB, I dont know if this will work but you can verify the sql statement like this: <cfoutput> <cfsavecontent variable="sql"> ...
Please post more code. Are you talking about the query to populate the select list? The first thing I do is a cfdump of the query at the top of the display ...
Here is code from my cfc: <cffunction name="loadCivilServiceOT" access="public" returntype="void" output="no"> <cfargument name="DEPT_CD" type="string" ...
OK, your stored procedure is expecting a date. I can't tell from here how you are doing it. I would need to see the fbx_switch, the cfc, and the dsp page. If...
Thanks, I've sent you the relavent portions. Sherry ... From: coldfusion-howto@yahoogroups.com [mailto:coldfusion-howto@yahoogroups.com] On Behalf Of Greg Luce...
Hi Can someone please tell me what I have done wrong below. I keep getting an error. Thanks! ... Error Executing Database Query. Syntax error in INSERT INTO...
First of all PLEASE use cfqueryparams. We would probably need to know the datatypes for all of the columns in the insert statement to be of help if that's all...
If you use CFQUERYPARAM you don't need to worry much about Syntax, but I think your error is stemming from your use of CreateODBCDateTime. That should be in...
Nope, you don't put quotes around CreateODBCDate or CreateODBCDateTime. OP: If you're getting an error, it's always good to let us know what error you are...
Thanks for the responses I copied and pasted the error when I sent the first email I will experiment with the CFQUERYPARAM suggested by the others. Error...
In the error message, it should give you the SQL it tried to execute. What does that say? Try using a different field name than "Password" and/or "Type". It...
If UserID is your primary key and you have autoincrement turned on in your database, then you don't send the userID in an insert, the database will autocreate...
Much Thanks Marty! Your suggestion fixed the problem. Best Regards Elsinore ... From: Marty Marbach <marty@...> To: coldfusion-howto@yahoogroups.com ...
Thanks John! I did as you suggested and renamed those 2 columns and also removed the UserID entry like Marty suggested and it worked ... From: John Bartlett...
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.
