Re: Query Var Disappears [spamtrap bayes][spamtrap heur]
> this should probably be a best practice for multiple SQL > statements in sql Yep. We use it for all stored procedures as well. Good for performance .. and your sanity ;-) > the mysterious mr. leigh ... sounds like the title of an old movie ;) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338610 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears [spamtrap bayes][spamtrap heur]
On 10/27/2010 7:45 AM, Leigh wrote: > Wrap the two statements in SET NOCOUNT ON / OFF the mysterious mr. leigh is quite right ;-) this should probably be a best practice for multiple SQL statements in sql server. it can shave off a few ms by stopping the server from returning anything to cf until its actually needed. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338609 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
> Out of curiosity, am I correct in thinking that the search > result that I > chose to click on and read was your blog? ;-) Yep. Though this one (not mine) is probably my favorite entry on the topic: http://www.mischefamily.com/nathan/index.cfm/2008/1/28/Problems-with-CF-8s-Generated-Keys-Feature The sql profiler details explained _so_ much of the CF8 weirdness ;-) -Leigh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Leigh, You, my dear, win the prize. Thanks for the tip. :-) Out of curiosity, am I correct in thinking that the search result that I chose to click on and read was your blog? ;-) http://cfsearching.blogspot.com/2008/02/coldfusion-8-query-results-are.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Disclaimer: I have not read every single response on this thread > And the result is a big fat "TMP is undefined" exception > being thrown. Wrap the two statements in SET NOCOUNT ON / OFF Though not all identical to your case, there were a _lot_ of blog entries on similar issues with inserts, the "result" attribute and scope_identity(). A search on CF8 / cfquery result attribute / scope_identity() should turn up a bunch of results. -Leigh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
*big grin* ;-) On Tue, 2010-10-26 at 14:25 -0700, Rick Colman wrote: > It is more than possible, it is likely ... typo ... > > SORRY > > On 10/26/2010 12:38 PM, Michael Grant wrote: > > Is it at all possible you've got the table name incorrect? > > > > On Tue, Oct 26, 2010 at 2:24 PM, Rick Colman wrote: > > > >> ok, maybe I am cross-eyed and (tried matching cases), but: > >> > >> PROTEINSEQUENCE1sdalifsdaifasifsadi > >> > >> equals > >> > >> '#form['ProteinSequence'&LoopCount]#', > >> > >> which is called AA_sequence in the data table as shown below > >> > >> Insert into ProteinSequence (Project_ID, AA_Sequence, ... > >> > >> this all seems to match up. > >> > >> ***Looping through an insert is certainly a very basic programming > >> operation. > >> Seems like it should not be so painful ... > >> > >> On 10/26/2010 11:15 AM, Bryan Stevenson wrote: > >>> Well I know you said in another post that the form elements are all > >>> there, but this error disagrees with you ;-) > >>> > >>> So it's time to check variable spellingpossibly caseother > >>> obvious yet silly things > >>> > >>> ...and of course you want to make sure that the complete set of form > >>> elements exist for ALL values of the loop (if any of these come from > >>> checkboxes, an unchecked on would cause some chaos for sure (as it would > >>> be undefined) > >>> > >>> HTH > >>> > >>> Cheers > >>> > >>> On Tue, 2010-10-26 at 11:07 -0700, Rick Colman wrote: > >>> > actually, two are int, so revised, but still did not work: > > > Error Executing Database Query. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name > 'ProteinSequence'. > The error occurred > in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: > line 77* > > 75 : '#form['ProteinSequence'&LoopCount]#', > 76 : '#form['genename'&LoopCount]#', > *77 : #form['NoAminoAcids'&LoopCount]#* > 78 : ) > 79 : > > > VENDORERRORCODE208 > SQLSTATE 42S02 > SQL Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, > Count) Values( 22, 'sdalifsdaifasifsadi', 'g1', 15 ) > DATASOURCE sttr2 > > > code: > > > > username="#request.dsn_username#" password="#request.dsn_password#"> > Insert into ProteinSequence > (Project_ID, > AA_Sequence, > Gene_Name, > Count) > Values( > #thisprojectid#, > '#form['ProteinSequence'& LoopCount]#', > '#form['genename'& LoopCount]#', > #form['NoAminoAcids'& LoopCount]# > ) > > > > cfdump: > > PROTEINSEQUENCE1 sdalifsdaifasifsadi > PROTEINSEQUENCE2 sdafklfsaklfsdklaf > > > >> > >> > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
> As I stated previously, if the > SELECT INTO clause returns more than one record, the database will throw an > exception. If the SELECT INTO would not work, then it would not exist in > the SQL specification. :-) Just a minor clarification, even though it might not solve your problem. You said you can't do a select into when the select returns more than one row. However, in your original SQL statement (in your very first message) you have "insert into myTable (fields) select ...". To be clear, this is not a select into...those are two different things. You may be aware of this, but for those following along in the thread I wanted to clarify. But just in case you are actually referring to an "insert into myTable select ...", you can in fact grab more than one row in the select and SQL Server will insert them just fine. I have not closely followed all of the messages in this thread, so if you are talking about something completely different, feel free to ignore me. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338604 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamically resizing a cfwindow?
Thanks. The problem seems to be that CF is dynamically appending a value to the window ID; for example, here's the HTML: Gallery That "cf_window1288130408876" bit changes with each page refresh, and I'm not sure where that value is coming from. Pete On Tue, Oct 26, 2010 at 9:32 AM, Brook Davies wrote: > > If you use firefox and firebug, turn on the inspection option in firebug > and > roll your mouse over the upper left corner of the window. You should be > able > to find the windows containing div, it should look something like this: > > class="x-window-tr">... > > > Find the ID of the containing div and in the firebug console type > Ext.getCmp('window-id'). This will dump all of the windows methods and > properties, look through it for the method you need and try calling it > directly via the console (eg. Ext.getCmp('window-id').setPosition(x,y) > > Now, I have never used Coldfusions Ext implementation, and this is only how > I would do it with the standalone Ext library. I don't know if it will work > the same. I assume that the Ext namespace exists and can be used like this? > But I could be wrong... > > Brook > > -Original Message- > From: Andrew Scott [mailto:andr...@andyscott.id.au] > Sent: October-25-10 7:28 PM > To: cf-talk > Subject: RE: Dynamically resizing a cfwindow? > > > Which version of ColdFusion are you trying this on? > > Regards, > Andrew Scott > http://www.andyscott.id.au/ > > > -Original Message- > > From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] > > Sent: Tuesday, 26 October 2010 12:38 PM > > To: cf-talk > > Subject: Re: Dynamically resizing a cfwindow? > > > > > > Not sure if I follow. Put the code in the parent window? I tried that, > works in > > IE, doesn't work in Chrome. > > > > The interesting thing is that when I launch the cfwindow using IE (I > normally > > use Chrome), it resizes the parent window, but not the cfwindow (even > > though the this.resizeTo() code is in the page loaded within the > cfwindow). > > > > Pete > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338603 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
BTW...I have seen invalid object when queries are malformedsee post your real query ;-) I'm not trying to be a tool by asking for it...all it takes is a comma out of place and things go wrong. There have been many occasions where I was a certain about the details of my "real" code that I didn't double checksure enough things were not as I thought. Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338602 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamically resizing a cfwindow?
It's a modal window created via cfwindow. I'm on CF9. On Tue, Oct 26, 2010 at 9:56 AM, Michael Grant wrote: > > Wait a second. Is that actually a window or is this a modal "window" ? > If it's the latter than none of the advice I gave is going to work since > it's all for targeting an actual window. > > > > On Tue, Oct 26, 2010 at 9:32 AM, Brook Davies > wrote: > > > > > If you use firefox and firebug, turn on the inspection option in firebug > > and > > roll your mouse over the upper left corner of the window. You should be > > able > > to find the windows containing div, it should look something like this: > > > > style="position: > > absolute; z-index: 1003; visibility: visible; left: 374px; top: 73px; > > width: > > 1070px; display: block;"> > class="x-window-tr">... > > > > > > Find the ID of the containing div and in the firebug console type > > Ext.getCmp('window-id'). This will dump all of the windows methods and > > properties, look through it for the method you need and try calling it > > directly via the console (eg. Ext.getCmp('window-id').setPosition(x,y) > > > > Now, I have never used Coldfusions Ext implementation, and this is only > how > > I would do it with the standalone Ext library. I don't know if it will > work > > the same. I assume that the Ext namespace exists and can be used like > this? > > But I could be wrong... > > > > Brook > > > > -Original Message- > > From: Andrew Scott [mailto:andr...@andyscott.id.au] > > Sent: October-25-10 7:28 PM > > To: cf-talk > > Subject: RE: Dynamically resizing a cfwindow? > > > > > > Which version of ColdFusion are you trying this on? > > > > Regards, > > Andrew Scott > > http://www.andyscott.id.au/ > > > > > -Original Message- > > > From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] > > > Sent: Tuesday, 26 October 2010 12:38 PM > > > To: cf-talk > > > Subject: Re: Dynamically resizing a cfwindow? > > > > > > > > > Not sure if I follow. Put the code in the parent window? I tried > that, > > works in > > > IE, doesn't work in Chrome. > > > > > > The interesting thing is that when I launch the cfwindow using IE (I > > normally > > > use Chrome), it resizes the parent window, but not the cfwindow (even > > > though the this.resizeTo() code is in the page loaded within the > > cfwindow). > > > > > > Pete > > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
It is more than possible, it is likely ... typo ... SORRY On 10/26/2010 12:38 PM, Michael Grant wrote: > Is it at all possible you've got the table name incorrect? > > On Tue, Oct 26, 2010 at 2:24 PM, Rick Colman wrote: > >> ok, maybe I am cross-eyed and (tried matching cases), but: >> >> PROTEINSEQUENCE1sdalifsdaifasifsadi >> >> equals >> >> '#form['ProteinSequence'&LoopCount]#', >> >> which is called AA_sequence in the data table as shown below >> >> Insert into ProteinSequence (Project_ID, AA_Sequence, ... >> >> this all seems to match up. >> >> ***Looping through an insert is certainly a very basic programming >> operation. >> Seems like it should not be so painful ... >> >> On 10/26/2010 11:15 AM, Bryan Stevenson wrote: >>> Well I know you said in another post that the form elements are all >>> there, but this error disagrees with you ;-) >>> >>> So it's time to check variable spellingpossibly caseother >>> obvious yet silly things >>> >>> ...and of course you want to make sure that the complete set of form >>> elements exist for ALL values of the loop (if any of these come from >>> checkboxes, an unchecked on would cause some chaos for sure (as it would >>> be undefined) >>> >>> HTH >>> >>> Cheers >>> >>> On Tue, 2010-10-26 at 11:07 -0700, Rick Colman wrote: >>> actually, two are int, so revised, but still did not work: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'ProteinSequence'. The error occurred in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: line 77* 75 : '#form['ProteinSequence'&LoopCount]#', 76 : '#form['genename'&LoopCount]#', *77 : #form['NoAminoAcids'&LoopCount]#* 78 : ) 79 : VENDORERRORCODE208 SQLSTATE 42S02 SQL Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( 22, 'sdalifsdaifasifsadi', 'g1', 15 ) DATASOURCE sttr2 code: >>> username="#request.dsn_username#" password="#request.dsn_password#"> Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( #thisprojectid#, '#form['ProteinSequence'& LoopCount]#', '#form['genename'& LoopCount]#', #form['NoAminoAcids'& LoopCount]# ) cfdump: PROTEINSEQUENCE1 sdalifsdaifasifsadi PROTEINSEQUENCE2 sdafklfsaklfsdklaf >> >> > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
Rickjust relax man.you want help you will have to answer questionsno matter how obvious they may be. Clearly you can't figure it out and you have the real codewe only have your pseudo code and are not inside your head 'nuff said On Tue, 2010-10-26 at 14:17 -0700, Rick Colman wrote: > yes , yes (arghhh!!) > > On 10/26/2010 12:35 PM, Bryan Stevenson wrote: > > ...and you have verified that the table name is in fact > > "ProteinSequence"? and that your datasource is pointing at the correct > > DB? > > > > an invalid object error does seem to point to the DB/table > > > > On Tue, 2010-10-26 at 11:24 -0700, Rick Colman wrote: > > > >> ok, maybe I am cross-eyed and (tried matching cases), but: > >> > >> PROTEINSEQUENCE1 sdalifsdaifasifsadi > >> > >> equals > >> > >> '#form['ProteinSequence'&LoopCount]#', > >> > >> which is called AA_sequence in the data table as shown below > >> > >> Insert into ProteinSequence (Project_ID, AA_Sequence, ... > >> > >> this all seems to match up. > >> > >> ***Looping through an insert is certainly a very basic programming > >> operation. > >> Seems like it should not be so painful ... > > > > Bryan Stevenson B.Comm. > > VP& Director of E-Commerce Development > > Electric Edge Systems Group Inc. > > phone: 250.480.0642 > > fax: 250.480.1264 > > cell: 250.920.8830 > > e-mail: br...@electricedgesystems.com > > web: www.electricedgesystems.com > > > > Notice: > > This message, including any attachments, is confidential and may contain > > information that is privileged or exempt from disclosure. It is intended > > only for the person to whom it is addressed unless expressly authorized > > otherwise by the sender. If you are not an authorized recipient, please > > notify the sender immediately and permanently destroy all copies of this > > message and attachments. > > Please consider the environment before printing this e-mail > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338599 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Apache Axis Does Not Generate All Classes of Web Service
This is more than likely a schema problem. I've had this before with Axis/CF. Some schema in the WSDL lacks a defined name space and Axis just Throws the classes into the default package. Then when java tries to compile the generated .java file you get an error. Not sure how the command line works for wsdl2java(never used it) in maven(not recommended if you're not familiar with it) I define a default package and all works out in the end. Adam On Wed, Oct 20, 2010 at 2:37 PM, Donnie Carvajal < donnie.carva...@transformyx.com> wrote: > > I am having a problem with the NetSuite wsdl. There are stub class files > that are missing. I've seen some posts in some other forums indicating that > when the web service is setup through Coldfusion, there are class files > missing, but when wsdl2java is run from the command line, it works just > fine. > > Is anyone else experiencing this problem with any other web services? If > so, is there a fix or do I need to compile all wsdl classes from the command > line from here on out? > > Thanks, > > Donnie > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338598 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
yes , yes (arghhh!!) On 10/26/2010 12:35 PM, Bryan Stevenson wrote: > ...and you have verified that the table name is in fact > "ProteinSequence"? and that your datasource is pointing at the correct > DB? > > an invalid object error does seem to point to the DB/table > > On Tue, 2010-10-26 at 11:24 -0700, Rick Colman wrote: > >> ok, maybe I am cross-eyed and (tried matching cases), but: >> >> PROTEINSEQUENCE1 sdalifsdaifasifsadi >> >> equals >> >> '#form['ProteinSequence'&LoopCount]#', >> >> which is called AA_sequence in the data table as shown below >> >> Insert into ProteinSequence (Project_ID, AA_Sequence, ... >> >> this all seems to match up. >> >> ***Looping through an insert is certainly a very basic programming operation. >> Seems like it should not be so painful ... > > Bryan Stevenson B.Comm. > VP& Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: br...@electricedgesystems.com > web: www.electricedgesystems.com > > Notice: > This message, including any attachments, is confidential and may contain > information that is privileged or exempt from disclosure. It is intended > only for the person to whom it is addressed unless expressly authorized > otherwise by the sender. If you are not an authorized recipient, please > notify the sender immediately and permanently destroy all copies of this > message and attachments. > Please consider the environment before printing this e-mail > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338597 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
sdalifsdaifasifsadi which is what it should be ... On 10/26/2010 11:55 AM, Michael Grant wrote: > #form['ProteinSequence'&1]# ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338596 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
here it is: struct COMMONNAME1 Bacillus subtilis EXPORG_ID1 314 FIELDNAMES NUM_GENES,PROJECTNAME,PURPOSE,GENENAME1,PROTEINSEQUENCE1,NOAMINOACIDS1,GENENAME2,PROTEINSEQUENCE2,NOAMINOACIDS2,EXPORG_ID1,COMMONNAME1,NOTES GENENAME1 g1 GENENAME2 g2 NOAMINOACIDS1 15 NOAMINOACIDS2 15 NOTES [empty string] NUM_GENES 2 PROJECTNAME t esting PROTEINSEQUENCE1sdalifsdaifasifsadi PROTEINSEQUENCE2sdafklfsaklfsdklaf PURPOSE testing On 10/26/2010 11:30 AM, Carl Von Stetten wrote: > Rick, > > Can you provide a dump of the FORM scope? > > Thanks, > Carl > >> ok, maybe I am cross-eyed and (tried matching cases), but: >> >> PROTEINSEQUENCE1 sdalifsdaifasifsadi >> >> equals >> >> '#form['ProteinSequence'&LoopCount]#', >> >> which is called AA_sequence in the data table as shown below >> >> Insert into ProteinSequence (Project_ID, AA_Sequence, ... >> >> this all seems to match up. >> >> ***Looping through an insert is certainly a very basic programming operation. >> Seems like it should not be so painful ... >> >> On 10/26/2010 11:15 AM, Bryan Stevenson wrote: > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
You sure it is an issue with the CF version and not the SQL version? It seems odd that CF would treat SQL differently since it just passes it through. Typically when an obviously defined CF variable shows up undefined it is b/c something in Java is returning a NULL. Adam On Tue, Oct 26, 2010 at 4:10 PM, Matt Quackenbush wrote: > > @ Bryan- > > The SELECT INTO insert query will work perfectly fine *as long as you're > not > also trying to grab the newly inserted ID*. As I stated previously, if the > SELECT INTO clause returns more than one record, the database will throw an > exception. If the SELECT INTO would not work, then it would not exist in > the SQL specification. :-) > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
On Tue, 2010-10-26 at 15:10 -0500, Matt Quackenbush wrote: > @ Bryan- > > The SELECT INTO insert query will work perfectly fine *as long as you're not > also trying to grab the newly inserted ID*. I 100% got that and understand itthat is why your query doesn't work...because you are trying to grab the newly inserted ID > As I stated previously, if the > SELECT INTO clause returns more than one record, the database will throw an > exception. If the SELECT INTO would not work, then it would not exist in > the SQL specification. :-) LOL...you seem to think that because something is in the SQL spec that it will in fact have been implemented or implemented properly ;-) and which "SQL specification" are you referring to? T-SQL or PL-SQL or something else? Regardless...your issue seems to be the new ID stuff...so you seem to be sorted. Cheers > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
@ Bryan- The SELECT INTO insert query will work perfectly fine *as long as you're not also trying to grab the newly inserted ID*. As I stated previously, if the SELECT INTO clause returns more than one record, the database will throw an exception. If the SELECT INTO would not work, then it would not exist in the SQL specification. :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
I'll take it! On Tue, Oct 26, 2010 at 4:04 PM, Bryan Stevenson < br...@electricedgesystems.com> wrote: > > SorryI replied with my plus 1 before seeing Matt's post about the > error. I still think that is the reason it doesn't work (error or not). > > On Tue, 2010-10-26 at 15:47 -0400, David McGraw wrote: > > > I guess I am so lost, I thought Matt just said what I suggested would > > generate an error? > > > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: br...@electricedgesystems.com > web: www.electricedgesystems.com > > Notice: > This message, including any attachments, is confidential and may contain > information that is privileged or exempt from disclosure. It is intended > only for the person to whom it is addressed unless expressly authorized > otherwise by the sender. If you are not an authorized recipient, please > notify the sender immediately and permanently destroy all copies of this > message and attachments. > Please consider the environment before printing this e-mail > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338591 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
SorryI replied with my plus 1 before seeing Matt's post about the error. I still think that is the reason it doesn't work (error or not). On Tue, 2010-10-26 at 15:47 -0400, David McGraw wrote: > I guess I am so lost, I thought Matt just said what I suggested would > generate an error? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338590 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
I guess I am so lost, I thought Matt just said what I suggested would generate an error? On Tue, Oct 26, 2010 at 3:42 PM, Bryan Stevenson < br...@electricedgesystems.com> wrote: > > plus one for David's explanation re: new ID...nail hit on head ;-) > > On Tue, 2010-10-26 at 15:35 -0400, David McGraw wrote: > > > Probably becuase when using a SELECT INTO you can potential insert more > than > > just 1 record, so that probably doesn't work with that. What does TMP > look > > liek when you just dump that after the query? Maybe it's an array of > IDs? > > Doubt it, but that's what I would assume since it could in theory return > > multiple "New Ids" > > > > On Tue, Oct 26, 2010 at 3:30 PM, Matt Quackenbush >wrote: > > > > > > > > Thanks. As I already posted, it's a bug in CF8. For some reason, CF8 > does > > > not properly handle an SELECT INTO insert, and does not return the new > ID. > > > So the workaround is to use a standard VALUES insert instead. > > > > > > Now then, if you do not need to know the newly inserted ID, then CF8 > > > handles > > > the SELECT INTO just fine. > > > > > > > > > > > > INSERT INTO > > > myTable > > > SELECT > > > 'foo', > > > myOtherTable.IDcol > > > FROM > > > myOtherTable > > > WHERE > > > myOtherTable.bar = 'wtf?' > > > ; > > > > > > > > > However, this fails when you try and reference the query/new ID. > > > > > > > > > INSERT INTO > > > myTable > > > SELECT > > > 'foo', > > > myOtherTable.IDcol > > > FROM > > > myOtherTable > > > WHERE > > > myOtherTable.bar = 'wtf?' > > > ; > > > SELECT > > > scope_identity() AS NewId > > > FROM > > > myTable > > > ; > > > > > > > > > > > > Even if you use the 'result' attribute instead of the 'name' attribute, > the > > > query will do the insert, but the 'identitycol' key is undefined in the > > > 'result' struct. > > > > > > > > > INSERT INTO > > > myTable > > > SELECT > > > 'foo', > > > myOtherTable.IDcol > > > FROM > > > myOtherTable > > > WHERE > > > myOtherTable.bar = 'wtf?' > > > ; > > > > > > > > > > > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
plus one for David's explanation re: new ID...nail hit on head ;-) On Tue, 2010-10-26 at 15:35 -0400, David McGraw wrote: > Probably becuase when using a SELECT INTO you can potential insert more than > just 1 record, so that probably doesn't work with that. What does TMP look > liek when you just dump that after the query? Maybe it's an array of IDs? > Doubt it, but that's what I would assume since it could in theory return > multiple "New Ids" > > On Tue, Oct 26, 2010 at 3:30 PM, Matt Quackenbush wrote: > > > > > Thanks. As I already posted, it's a bug in CF8. For some reason, CF8 does > > not properly handle an SELECT INTO insert, and does not return the new ID. > > So the workaround is to use a standard VALUES insert instead. > > > > Now then, if you do not need to know the newly inserted ID, then CF8 > > handles > > the SELECT INTO just fine. > > > > > > > > INSERT INTO > > myTable > > SELECT > > 'foo', > > myOtherTable.IDcol > > FROM > > myOtherTable > > WHERE > > myOtherTable.bar = 'wtf?' > > ; > > > > > > However, this fails when you try and reference the query/new ID. > > > > > > INSERT INTO > > myTable > > SELECT > > 'foo', > > myOtherTable.IDcol > > FROM > > myOtherTable > > WHERE > > myOtherTable.bar = 'wtf?' > > ; > > SELECT > > scope_identity() AS NewId > > FROM > > myTable > > ; > > > > > > > > Even if you use the 'result' attribute instead of the 'name' attribute, the > > query will do the insert, but the 'identitycol' key is undefined in the > > 'result' struct. > > > > > > INSERT INTO > > myTable > > SELECT > > 'foo', > > myOtherTable.IDcol > > FROM > > myOtherTable > > WHERE > > myOtherTable.bar = 'wtf?' > > ; > > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338588 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
Is it at all possible you've got the table name incorrect? On Tue, Oct 26, 2010 at 2:24 PM, Rick Colman wrote: > > ok, maybe I am cross-eyed and (tried matching cases), but: > > PROTEINSEQUENCE1sdalifsdaifasifsadi > > equals > > '#form['ProteinSequence'& LoopCount]#', > > which is called AA_sequence in the data table as shown below > > Insert into ProteinSequence (Project_ID, AA_Sequence, ... > > this all seems to match up. > > ***Looping through an insert is certainly a very basic programming > operation. > Seems like it should not be so painful ... > > On 10/26/2010 11:15 AM, Bryan Stevenson wrote: > > Well I know you said in another post that the form elements are all > > there, but this error disagrees with you ;-) > > > > So it's time to check variable spellingpossibly caseother > > obvious yet silly things > > > > ...and of course you want to make sure that the complete set of form > > elements exist for ALL values of the loop (if any of these come from > > checkboxes, an unchecked on would cause some chaos for sure (as it would > > be undefined) > > > > HTH > > > > Cheers > > > > On Tue, 2010-10-26 at 11:07 -0700, Rick Colman wrote: > > > >> actually, two are int, so revised, but still did not work: > >> > >> > >>Error Executing Database Query. > >> > >> [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name > >> 'ProteinSequence'. > >> The error occurred > >> in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: > >> line 77* > >> > >> 75 : '#form['ProteinSequence'& LoopCount]#', > >> 76 : '#form['genename'& LoopCount]#', > >> *77 : #form['NoAminoAcids'& LoopCount]#* > >> 78 : ) > >> 79 : > >> > >> > >> VENDORERRORCODE208 > >> SQLSTATE 42S02 > >> SQL Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, > >> Count) Values( 22, 'sdalifsdaifasifsadi', 'g1', 15 ) > >> DATASOURCE sttr2 > >> > >> > >> code: > >> > >> > >> > >> >> username="#request.dsn_username#" password="#request.dsn_password#"> > >> Insert into ProteinSequence > >> (Project_ID, > >>AA_Sequence, > >>Gene_Name, > >>Count) > >>Values( > >>#thisprojectid#, > >>'#form['ProteinSequence'& LoopCount]#', > >>'#form['genename'& LoopCount]#', > >>#form['NoAminoAcids'& LoopCount]# > >>) > >> > >> > >> > >> cfdump: > >> > >> PROTEINSEQUENCE1 sdalifsdaifasifsadi > >> PROTEINSEQUENCE2 sdafklfsaklfsdklaf > >> > >> > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338587 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
If the select into returned more than one record, an exception is thrown from the db server. :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338586 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
@Allen No I don'tnot in the SELECT clausewhat the heck kind of user input would I be using in my SELECT clause?? In my WHERE clauses...of course...all the time without fail. FYI..."clause" does not equal "statement"I think that is where you misread my previous post ;-) Cheers On Tue, 2010-10-26 at 11:33 -0700, Alan Rother wrote: > Bryan and Matt, please tell me you use cfqueryparam on your SELECT > statements where you accept user provided information such as FORM or URL > variables... right? > > If you don't you are exposing yourselves to SQL Injection attacks, it's not > just on INSERT and UPDATE statements that you are vulnerable, it's anytime > you access your DB and pass in values from your users. > > As a rule of thumb here, we never write a query without a cfqueryparam tag > > > =] > > On Tue, Oct 26, 2010 at 11:24 AM, Matt Quackenbush > wrote: > > > > > @ Bryan- > > > > You are apparently correct on #1. I shall try and remember that in the > > future. It is now obvious to me that stating that the code works > > absolutely > > perfectly in one environment does not lead to everyone understanding that > > it > > is not an issue of incomplete code. > > > > As for #2, it is a SELECT INTO statement, so, yes, it needs > />. I too have never seen in a normal SELECT FROM > > statement. > > > > @ All- > > > > It seems that I have managed to find not one, but two bugs in CF8.0.1. I > > will post the bug reports as soon as I have had an opportunity to make > > them. > > > > For those who might stumble across this post in the future, the workaround > > is two-fold: > > > > 1) Use the 'result' attribute on instead of the 'name' attribute. > > (Grab the newly inserted ID from 'result.identitycol'.) > > > > 2) Use a standard 'VALUES' insert, rather than a 'SELECT' insert. If you > > need the lookup on a value (e.g. when you'd normally use a 'SELECT' > > insert), > > you can either make a prior db call to get the value(s), or you can have a > > lookup struct/query in cache to pull the values from. > > > > HTH > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338585 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Ok.. My Bad I did not get that at all from the post. That is SUPER weird. I have also never seen nor done that before... But makes sense in a SELECT INTO @ Alan- Perhaps I misunderstood Bryan's question/comment, but you (and therefore probably others) definitely misunderstood mine. This is what I have *not* ever seen... SELECT FROM table On Tue, Oct 26, 2010 at 12:30 PM, Matt Quackenbush wrote: > > Thanks. As I already posted, it's a bug in CF8. For some reason, CF8 does > not properly handle an SELECT INTO insert, and does not return the new ID. > So the workaround is to use a standard VALUES insert instead. > > Now then, if you do not need to know the newly inserted ID, then CF8 > handles > the SELECT INTO just fine. > > > > INSERT INTO > myTable > SELECT > 'foo', > myOtherTable.IDcol > FROM > myOtherTable > WHERE > myOtherTable.bar = 'wtf?' > ; > > > However, this fails when you try and reference the query/new ID. > > > INSERT INTO > myTable > SELECT > 'foo', > myOtherTable.IDcol > FROM > myOtherTable > WHERE > myOtherTable.bar = 'wtf?' > ; > SELECT > scope_identity() AS NewId > FROM > myTable > ; > > > > Even if you use the 'result' attribute instead of the 'name' attribute, the > query will do the insert, but the 'identitycol' key is undefined in the > 'result' struct. > > > INSERT INTO > myTable > SELECT > 'foo', > myOtherTable.IDcol > FROM > myOtherTable > WHERE > myOtherTable.bar = 'wtf?' > ; > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338584 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
...and you have verified that the table name is in fact "ProteinSequence"? and that your datasource is pointing at the correct DB? an invalid object error does seem to point to the DB/table On Tue, 2010-10-26 at 11:24 -0700, Rick Colman wrote: > ok, maybe I am cross-eyed and (tried matching cases), but: > > PROTEINSEQUENCE1 sdalifsdaifasifsadi > > equals > > '#form['ProteinSequence'& LoopCount]#', > > which is called AA_sequence in the data table as shown below > > Insert into ProteinSequence (Project_ID, AA_Sequence, ... > > this all seems to match up. > > ***Looping through an insert is certainly a very basic programming operation. > Seems like it should not be so painful ... Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338583 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Probably becuase when using a SELECT INTO you can potential insert more than just 1 record, so that probably doesn't work with that. What does TMP look liek when you just dump that after the query? Maybe it's an array of IDs? Doubt it, but that's what I would assume since it could in theory return multiple "New Ids" On Tue, Oct 26, 2010 at 3:30 PM, Matt Quackenbush wrote: > > Thanks. As I already posted, it's a bug in CF8. For some reason, CF8 does > not properly handle an SELECT INTO insert, and does not return the new ID. > So the workaround is to use a standard VALUES insert instead. > > Now then, if you do not need to know the newly inserted ID, then CF8 > handles > the SELECT INTO just fine. > > > > INSERT INTO > myTable > SELECT > 'foo', > myOtherTable.IDcol > FROM > myOtherTable > WHERE > myOtherTable.bar = 'wtf?' > ; > > > However, this fails when you try and reference the query/new ID. > > > INSERT INTO > myTable > SELECT > 'foo', > myOtherTable.IDcol > FROM > myOtherTable > WHERE > myOtherTable.bar = 'wtf?' > ; > SELECT > scope_identity() AS NewId > FROM > myTable > ; > > > > Even if you use the 'result' attribute instead of the 'name' attribute, the > query will do the insert, but the 'identitycol' key is undefined in the > 'result' struct. > > > INSERT INTO > myTable > SELECT > 'foo', > myOtherTable.IDcol > FROM > myOtherTable > WHERE > myOtherTable.bar = 'wtf?' > ; > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338582 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Thanks. As I already posted, it's a bug in CF8. For some reason, CF8 does not properly handle an SELECT INTO insert, and does not return the new ID. So the workaround is to use a standard VALUES insert instead. Now then, if you do not need to know the newly inserted ID, then CF8 handles the SELECT INTO just fine. INSERT INTO myTable SELECT 'foo', myOtherTable.IDcol FROM myOtherTable WHERE myOtherTable.bar = 'wtf?' ; However, this fails when you try and reference the query/new ID. INSERT INTO myTable SELECT 'foo', myOtherTable.IDcol FROM myOtherTable WHERE myOtherTable.bar = 'wtf?' ; SELECT scope_identity() AS NewId FROM myTable ; Even if you use the 'result' attribute instead of the 'name' attribute, the query will do the insert, but the 'identitycol' key is undefined in the 'result' struct. INSERT INTO myTable SELECT 'foo', myOtherTable.IDcol FROM myOtherTable WHERE myOtherTable.bar = 'wtf?' ; ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Ahhh... I have gotten that error before, but it was so long ago, I don't remember what the cause or the fix was. Good luck! On Tue, Oct 26, 2010 at 3:17 PM, Matt Quackenbush wrote: > > It was never missing from the real code. Again, I posted pseudo code in > order to save everyone from having to read 100 lines of superfluous code, > but to show the basic concepts of the query in question. And, again, as > stated previously, the issue is caused by a bug in CF8.0.1 in relation to > SELECT INTO rather than a standard VALUES insert. > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338580 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Sigh. Good luck Matt, I know you'll figure it out eventually. On Tue, Oct 26, 2010 at 3:03 PM, Matt Quackenbush wrote: > > @ Michael- > > You obviously do not know me. And your statement that I "can't get a > simple > insert to work" proves that you have no interest in reading the thread or > actually helping, so why bother to post? > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338579 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
It was never missing from the real code. Again, I posted pseudo code in order to save everyone from having to read 100 lines of superfluous code, but to show the basic concepts of the query in question. And, again, as stated previously, the issue is caused by a bug in CF8.0.1 in relation to SELECT INTO rather than a standard VALUES insert. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338578 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
I stand corrected... however did you add it and did it fix it? On Tue, Oct 26, 2010 at 3:10 PM, Matt Quackenbush wrote: > > Actually, that is incorrect. cfsqltype is **not** a required attribute for > . If omitted, it defaults to cf_sql_char. > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Actually, that is incorrect. cfsqltype is **not** a required attribute for . If omitted, it defaults to cf_sql_char. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338576 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Not sure if this was suggested, but when you use cfqueryparam you need to specify a type as well, not just a value. Try adding int the CF_SQL_TYPE attribute... Thanks, David McGraw Oyova Software, LLC http://www.oyova.com On Tue, Oct 26, 2010 at 3:03 PM, Matt Quackenbush wrote: > > @ Michael- > > You obviously do not know me. And your statement that I "can't get a > simple > insert to work" proves that you have no interest in reading the thread or > actually helping, so why bother to post? > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
@ Gerald- Yes, I tried changing the name of the query, even though 'tmp' is definitely *not* a reserved word in CF. Again, the issue, as I already posted, is that I found two bugs in CF 8.0.1. Please see the previous post for the details and workarounds. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
@ Michael- You obviously do not know me. And your statement that I "can't get a simple insert to work" proves that you have no interest in reading the thread or actually helping, so why bother to post? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
@ Alan- Perhaps I misunderstood Bryan's question/comment, but you (and therefore probably others) definitely misunderstood mine. This is what I have *not* ever seen... SELECT FROM table ; That is the 'SELECT FROM' that I was referring to. I was ***not*** referring to the WHERE clause of a select statement. should absolutely always be used for user-provided data, and one can make the argument that it should be used regardless. My apologies for the confusion in my post. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338572 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
Diagnostics time. take the loop and the query right out of it, what happens when you add this at the top of your page: #form['ProteinSequence' & 1]# On Tue, Oct 26, 2010 at 2:24 PM, Rick Colman wrote: > > ok, maybe I am cross-eyed and (tried matching cases), but: > > PROTEINSEQUENCE1sdalifsdaifasifsadi > > equals > > '#form['ProteinSequence'& LoopCount]#', > > which is called AA_sequence in the data table as shown below > > Insert into ProteinSequence (Project_ID, AA_Sequence, ... > > this all seems to match up. > > ***Looping through an insert is certainly a very basic programming > operation. > Seems like it should not be so painful ... > > On 10/26/2010 11:15 AM, Bryan Stevenson wrote: > > Well I know you said in another post that the form elements are all > > there, but this error disagrees with you ;-) > > > > So it's time to check variable spellingpossibly caseother > > obvious yet silly things > > > > ...and of course you want to make sure that the complete set of form > > elements exist for ALL values of the loop (if any of these come from > > checkboxes, an unchecked on would cause some chaos for sure (as it would > > be undefined) > > > > HTH > > > > Cheers > > > > On Tue, 2010-10-26 at 11:07 -0700, Rick Colman wrote: > > > >> actually, two are int, so revised, but still did not work: > >> > >> > >>Error Executing Database Query. > >> > >> [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name > >> 'ProteinSequence'. > >> The error occurred > >> in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: > >> line 77* > >> > >> 75 : '#form['ProteinSequence'& LoopCount]#', > >> 76 : '#form['genename'& LoopCount]#', > >> *77 : #form['NoAminoAcids'& LoopCount]#* > >> 78 : ) > >> 79 : > >> > >> > >> VENDORERRORCODE208 > >> SQLSTATE 42S02 > >> SQL Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, > >> Count) Values( 22, 'sdalifsdaifasifsadi', 'g1', 15 ) > >> DATASOURCE sttr2 > >> > >> > >> code: > >> > >> > >> > >> >> username="#request.dsn_username#" password="#request.dsn_password#"> > >> Insert into ProteinSequence > >> (Project_ID, > >>AA_Sequence, > >>Gene_Name, > >>Count) > >>Values( > >>#thisprojectid#, > >>'#form['ProteinSequence'& LoopCount]#', > >>'#form['genename'& LoopCount]#', > >>#form['NoAminoAcids'& LoopCount]# > >>) > >> > >> > >> > >> cfdump: > >> > >> PROTEINSEQUENCE1 sdalifsdaifasifsadi > >> PROTEINSEQUENCE2 sdafklfsaklfsdklaf > >> > >> > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338571 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
> > It is now obvious to me that stating that the code works > absolutely perfectly in one environment does not lead to everyone > understanding that it is not an issue of incomplete code. > You're talking about jumping completely different versions so there is absolutely no caveat that it's not an issue of incomplete code. Not sure why you've got such a chip on your shoulder considering you are the one who can't even get a simple insert to work. You'd think you'd be a little more contrite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338570 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
A shot in the dark but, could "tmp" be a reserved word or some such? Did you try changing the name of the query? Just a guess. G! On Tue, Oct 26, 2010 at 1:21 PM, Matt Quackenbush wrote: > > Okay, I cannot for the life of me figure this one out. This is essentially > a basic CF insert... > > > insert into foo (field,list) > select > , > othertable.field > from > othertable > where > othertable.otherfield = > ; > select scope_identity() as newID from foo; > > > > And the result is a big fat "TMP is undefined" exception being thrown. > > This code is being run on CF 8.0.1 against SQL Server 2003. The exact same > code works flawlessly on CF9.0.1 against SQL Server 2008. > > Any ideas? > > Thanks in advance. > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
Rick, Can you provide a dump of the FORM scope? Thanks, Carl >ok, maybe I am cross-eyed and (tried matching cases), but: > >PROTEINSEQUENCE1 sdalifsdaifasifsadi > >equals > >'#form['ProteinSequence'& LoopCount]#', > >which is called AA_sequence in the data table as shown below > >Insert into ProteinSequence (Project_ID, AA_Sequence, ... > >this all seems to match up. > >***Looping through an insert is certainly a very basic programming operation. >Seems like it should not be so painful ... > >On 10/26/2010 11:15 AM, Bryan Stevenson wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Bryan and Matt, please tell me you use cfqueryparam on your SELECT statements where you accept user provided information such as FORM or URL variables... right? If you don't you are exposing yourselves to SQL Injection attacks, it's not just on INSERT and UPDATE statements that you are vulnerable, it's anytime you access your DB and pass in values from your users. As a rule of thumb here, we never write a query without a cfqueryparam tag =] On Tue, Oct 26, 2010 at 11:24 AM, Matt Quackenbush wrote: > > @ Bryan- > > You are apparently correct on #1. I shall try and remember that in the > future. It is now obvious to me that stating that the code works > absolutely > perfectly in one environment does not lead to everyone understanding that > it > is not an issue of incomplete code. > > As for #2, it is a SELECT INTO statement, so, yes, it needs />. I too have never seen in a normal SELECT FROM > statement. > > @ All- > > It seems that I have managed to find not one, but two bugs in CF8.0.1. I > will post the bug reports as soon as I have had an opportunity to make > them. > > For those who might stumble across this post in the future, the workaround > is two-fold: > > 1) Use the 'result' attribute on instead of the 'name' attribute. > (Grab the newly inserted ID from 'result.identitycol'.) > > 2) Use a standard 'VALUES' insert, rather than a 'SELECT' insert. If you > need the lookup on a value (e.g. when you'd normally use a 'SELECT' > insert), > you can either make a prior db call to get the value(s), or you can have a > lookup struct/query in cache to pull the values from. > > HTH > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
@ Bryan- You are apparently correct on #1. I shall try and remember that in the future. It is now obvious to me that stating that the code works absolutely perfectly in one environment does not lead to everyone understanding that it is not an issue of incomplete code. As for #2, it is a SELECT INTO statement, so, yes, it needs . I too have never seen in a normal SELECT FROM statement. @ All- It seems that I have managed to find not one, but two bugs in CF8.0.1. I will post the bug reports as soon as I have had an opportunity to make them. For those who might stumble across this post in the future, the workaround is two-fold: 1) Use the 'result' attribute on instead of the 'name' attribute. (Grab the newly inserted ID from 'result.identitycol'.) 2) Use a standard 'VALUES' insert, rather than a 'SELECT' insert. If you need the lookup on a value (e.g. when you'd normally use a 'SELECT' insert), you can either make a prior db call to get the value(s), or you can have a lookup struct/query in cache to pull the values from. HTH ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
ok, maybe I am cross-eyed and (tried matching cases), but: PROTEINSEQUENCE1sdalifsdaifasifsadi equals '#form['ProteinSequence'& LoopCount]#', which is called AA_sequence in the data table as shown below Insert into ProteinSequence (Project_ID, AA_Sequence, ... this all seems to match up. ***Looping through an insert is certainly a very basic programming operation. Seems like it should not be so painful ... On 10/26/2010 11:15 AM, Bryan Stevenson wrote: > Well I know you said in another post that the form elements are all > there, but this error disagrees with you ;-) > > So it's time to check variable spellingpossibly caseother > obvious yet silly things > > ...and of course you want to make sure that the complete set of form > elements exist for ALL values of the loop (if any of these come from > checkboxes, an unchecked on would cause some chaos for sure (as it would > be undefined) > > HTH > > Cheers > > On Tue, 2010-10-26 at 11:07 -0700, Rick Colman wrote: > >> actually, two are int, so revised, but still did not work: >> >> >>Error Executing Database Query. >> >> [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name >> 'ProteinSequence'. >> The error occurred >> in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: >> line 77* >> >> 75 : '#form['ProteinSequence'& LoopCount]#', >> 76 : '#form['genename'& LoopCount]#', >> *77 : #form['NoAminoAcids'& LoopCount]#* >> 78 : ) >> 79 : >> >> >> VENDORERRORCODE208 >> SQLSTATE 42S02 >> SQL Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, >> Count) Values( 22, 'sdalifsdaifasifsadi', 'g1', 15 ) >> DATASOURCE sttr2 >> >> >> code: >> >> >> >> > username="#request.dsn_username#" password="#request.dsn_password#"> >> Insert into ProteinSequence >> (Project_ID, >>AA_Sequence, >>Gene_Name, >>Count) >>Values( >>#thisprojectid#, >>'#form['ProteinSequence'& LoopCount]#', >>'#form['genename'& LoopCount]#', >>#form['NoAminoAcids'& LoopCount]# >>) >> >> >> >> cfdump: >> >> PROTEINSEQUENCE1 sdalifsdaifasifsadi >> PROTEINSEQUENCE2 sdafklfsaklfsdklaf >> >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
Well I know you said in another post that the form elements are all there, but this error disagrees with you ;-) So it's time to check variable spellingpossibly caseother obvious yet silly things ...and of course you want to make sure that the complete set of form elements exist for ALL values of the loop (if any of these come from checkboxes, an unchecked on would cause some chaos for sure (as it would be undefined) HTH Cheers On Tue, 2010-10-26 at 11:07 -0700, Rick Colman wrote: > actually, two are int, so revised, but still did not work: > > > Error Executing Database Query. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name > 'ProteinSequence'. > The error occurred > in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: > line 77* > > 75 : '#form['ProteinSequence'& LoopCount]#', > 76 : '#form['genename'& LoopCount]#', > *77 : #form['NoAminoAcids'& LoopCount]#* > 78 : ) > 79 : > > > VENDORERRORCODE 208 > SQLSTATE42S02 > SQL Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, > Count) Values( 22, 'sdalifsdaifasifsadi', 'g1', 15 ) > DATASOURCE sttr2 > > > code: > > > > username="#request.dsn_username#" password="#request.dsn_password#" > > Insert into ProteinSequence > (Project_ID, > AA_Sequence, > Gene_Name, > Count) > Values( > #thisprojectid#, > '#form['ProteinSequence' & LoopCount]#', > '#form['genename' & LoopCount]#', > #form['NoAminoAcids' & LoopCount]# > ) > > > > cfdump: > > PROTEINSEQUENCE1 sdalifsdaifasifsadi > PROTEINSEQUENCE2 sdafklfsaklfsdklaf > > > On 10/26/2010 11:00 AM, Michael Grant wrote: > > And Project_ID, AA_Sequence, Gene_Name and Count are all string fields? > > > > > > On Tue, Oct 26, 2010 at 1:58 PM, Rick Colman wrote: > > > >> It seems to die on the first loop because nothing gets inserted. Cfdump > >> shows the proper form variables being passed. > >> > >> > >> > >> >> username="#request.dsn_username#" password="#request.dsn_password#"> > >> > >> Insert into ProteinSequence > >> (Project_ID, > >> AA_Sequence, > >> Gene_Name, > >> Count) > >> Values( > >>'#thisprojectid#', > >> '#form["ProteinSequence"& LoopCount]#', > >> '#form["genename"& LoopCount]#', > >> '#form["NoAminoAcids"& LoopCount]#' > >> ) > >> > >> > >> > >> > >> > >> On 10/26/2010 10:51 AM, Michael Grant wrote: > >>> Could you post your code? > >>> If you only loop a single time do you still get the error? > >>> > >>> On Tue, Oct 26, 2010 at 1:47 PM, Rick Colman wrote: > >>> > that did not work. > > what is funny is that the debug sql statement looks ok : > > Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) > Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) > > On 10/26/2010 10:40 AM, Michael Grant wrote: > > Maybe try this instead: > > > > Values( > > '#thisprojectid#', > > '#form["ProteinSequence"&LoopCount]#', > > '#form["genename"&LoopCount]#', > > '#form["NoAminoAcids"&LoopCount]#' > > ) > > > > > > > >> > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
what happens if you put those into 's? On Tue, Oct 26, 2010 at 2:07 PM, Rick Colman wrote: > > actually, two are int, so revised, but still did not work: > > > Error Executing Database Query. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name > 'ProteinSequence'. > The error occurred > in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: > line 77* > > 75 : '#form['ProteinSequence'& LoopCount]#', > 76 : '#form['genename'& LoopCount]#', > *77 : #form['NoAminoAcids'& LoopCount]#* > 78 : ) > 79 : > > > VENDORERRORCODE 208 > SQLSTATE 42S02 > SQLInsert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, > Count) Values( 22, 'sdalifsdaifasifsadi', 'g1', 15 ) > DATASOURCEsttr2 > > > code: > > > > username="#request.dsn_username#" password="#request.dsn_password#" > > Insert into ProteinSequence > (Project_ID, > AA_Sequence, > Gene_Name, > Count) > Values( > #thisprojectid#, > '#form['ProteinSequence' & LoopCount]#', > '#form['genename' & LoopCount]#', > #form['NoAminoAcids' & LoopCount]# > ) > > > > cfdump: > > PROTEINSEQUENCE1sdalifsdaifasifsadi > PROTEINSEQUENCE2sdafklfsaklfsdklaf > > > On 10/26/2010 11:00 AM, Michael Grant wrote: > > And Project_ID, AA_Sequence, Gene_Name and Count are all string fields? > > > > > > On Tue, Oct 26, 2010 at 1:58 PM, Rick Colman wrote: > > > >> It seems to die on the first loop because nothing gets inserted. Cfdump > >> shows the proper form variables being passed. > >> > >> > >> > >> >> username="#request.dsn_username#" password="#request.dsn_password#"> > >> > >> Insert into ProteinSequence > >> (Project_ID, > >> AA_Sequence, > >> Gene_Name, > >> Count) > >> Values( > >>'#thisprojectid#', > >> '#form["ProteinSequence"& LoopCount]#', > >> '#form["genename"& LoopCount]#', > >> '#form["NoAminoAcids"& LoopCount]#' > >> ) > >> > >> > >> > >> > >> > >> On 10/26/2010 10:51 AM, Michael Grant wrote: > >>> Could you post your code? > >>> If you only loop a single time do you still get the error? > >>> > >>> On Tue, Oct 26, 2010 at 1:47 PM, Rick Colman wrote: > >>> > that did not work. > > what is funny is that the debug sql statement looks ok : > > Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, > Count) > Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) > > On 10/26/2010 10:40 AM, Michael Grant wrote: > > Maybe try this instead: > > > > Values( > > '#thisprojectid#', > > '#form["ProteinSequence"&LoopCount]#', > > '#form["genename"&LoopCount]#', > > '#form["NoAminoAcids"&LoopCount]#' > > ) > > > > > > > >> > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
yes, thank you, the form variables are actually there. On 10/26/2010 11:05 AM, Greg Morphis wrote: > Those are all coming from a form so have you tried dumping the form scope? > Make sure proteinsequence exists in the form > On Oct 26, 2010 12:59 PM, "Rick Colman" wrote: >> It seems to die on the first loop because nothing gets inserted. Cfdump >> shows the proper form variables being passed. >> >> >> >> > username="#request.dsn_username#" password="#request.dsn_password#"> >> >> Insert into ProteinSequence >> (Project_ID, >> AA_Sequence, >> Gene_Name, >> Count) >> Values( >> '#thisprojectid#', >> '#form["ProteinSequence"& LoopCount]#', >> '#form["genename"& LoopCount]#', >> '#form["NoAminoAcids"& LoopCount]#' >> ) >> >> >> >> >> >> On 10/26/2010 10:51 AM, Michael Grant wrote: >>> Could you post your code? >>> If you only loop a single time do you still get the error? >>> >>> On Tue, Oct 26, 2010 at 1:47 PM, Rick Colman wrote: >>> that did not work. what is funny is that the debug sql statement looks ok : Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) On 10/26/2010 10:40 AM, Michael Grant wrote: > Maybe try this instead: > > Values( > '#thisprojectid#', > '#form["ProteinSequence"& LoopCount]#', > '#form["genename"& LoopCount]#', > '#form["NoAminoAcids"& LoopCount]#' > ) > > > >> > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
actually, two are int, so revised, but still did not work: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'ProteinSequence'. The error occurred in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: line 77* 75 : '#form['ProteinSequence'& LoopCount]#', 76 : '#form['genename'& LoopCount]#', *77 : #form['NoAminoAcids'& LoopCount]#* 78 : ) 79 : VENDORERRORCODE 208 SQLSTATE 42S02 SQLInsert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( 22, 'sdalifsdaifasifsadi', 'g1', 15 ) DATASOURCEsttr2 code: Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( #thisprojectid#, '#form['ProteinSequence' & LoopCount]#', '#form['genename' & LoopCount]#', #form['NoAminoAcids' & LoopCount]# ) cfdump: PROTEINSEQUENCE1sdalifsdaifasifsadi PROTEINSEQUENCE2sdafklfsaklfsdklaf On 10/26/2010 11:00 AM, Michael Grant wrote: > And Project_ID, AA_Sequence, Gene_Name and Count are all string fields? > > > On Tue, Oct 26, 2010 at 1:58 PM, Rick Colman wrote: > >> It seems to die on the first loop because nothing gets inserted. Cfdump >> shows the proper form variables being passed. >> >> >> >> > username="#request.dsn_username#" password="#request.dsn_password#"> >> >> Insert into ProteinSequence >> (Project_ID, >> AA_Sequence, >> Gene_Name, >> Count) >> Values( >>'#thisprojectid#', >> '#form["ProteinSequence"& LoopCount]#', >> '#form["genename"& LoopCount]#', >> '#form["NoAminoAcids"& LoopCount]#' >> ) >> >> >> >> >> >> On 10/26/2010 10:51 AM, Michael Grant wrote: >>> Could you post your code? >>> If you only loop a single time do you still get the error? >>> >>> On Tue, Oct 26, 2010 at 1:47 PM, Rick Colman wrote: >>> that did not work. what is funny is that the debug sql statement looks ok : Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) On 10/26/2010 10:40 AM, Michael Grant wrote: > Maybe try this instead: > > Values( > '#thisprojectid#', > '#form["ProteinSequence"&LoopCount]#', > '#form["genename"&LoopCount]#', > '#form["NoAminoAcids"&LoopCount]#' > ) > > > >> > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
Those are all coming from a form so have you tried dumping the form scope? Make sure proteinsequence exists in the form On Oct 26, 2010 12:59 PM, "Rick Colman" wrote: > > It seems to die on the first loop because nothing gets inserted. Cfdump > shows the proper form variables being passed. > > > > username="#request.dsn_username#" password="#request.dsn_password#" > > > Insert into ProteinSequence > (Project_ID, > AA_Sequence, > Gene_Name, > Count) > Values( > '#thisprojectid#', > '#form["ProteinSequence" & LoopCount]#', > '#form["genename" & LoopCount]#', > '#form["NoAminoAcids" & LoopCount]#' > ) > > > > > > On 10/26/2010 10:51 AM, Michael Grant wrote: >> Could you post your code? >> If you only loop a single time do you still get the error? >> >> On Tue, Oct 26, 2010 at 1:47 PM, Rick Colman wrote: >> >>> that did not work. >>> >>> what is funny is that the debug sql statement looks ok : >>> >>> Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) >>> Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) >>> >>> On 10/26/2010 10:40 AM, Michael Grant wrote: Maybe try this instead: Values( '#thisprojectid#', '#form["ProteinSequence"& LoopCount]#', '#form["genename"& LoopCount]#', '#form["NoAminoAcids"& LoopCount]#' ) >>> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
And Project_ID, AA_Sequence, Gene_Name and Count are all string fields? On Tue, Oct 26, 2010 at 1:58 PM, Rick Colman wrote: > > It seems to die on the first loop because nothing gets inserted. Cfdump > shows the proper form variables being passed. > > > > username="#request.dsn_username#" password="#request.dsn_password#" > > > Insert into ProteinSequence > (Project_ID, > AA_Sequence, > Gene_Name, > Count) > Values( > '#thisprojectid#', > '#form["ProteinSequence" & LoopCount]#', > '#form["genename" & LoopCount]#', > '#form["NoAminoAcids" & LoopCount]#' > ) > > > > > > On 10/26/2010 10:51 AM, Michael Grant wrote: > > Could you post your code? > > If you only loop a single time do you still get the error? > > > > On Tue, Oct 26, 2010 at 1:47 PM, Rick Colman wrote: > > > >> that did not work. > >> > >> what is funny is that the debug sql statement looks ok : > >> > >> Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) > >> Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) > >> > >> On 10/26/2010 10:40 AM, Michael Grant wrote: > >>> Maybe try this instead: > >>> > >>>Values( > >>>'#thisprojectid#', > >>>'#form["ProteinSequence"& LoopCount]#', > >>>'#form["genename"& LoopCount]#', > >>>'#form["NoAminoAcids"& LoopCount]#' > >>>) > >>> > >>> > >>> > >> > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
It seems to die on the first loop because nothing gets inserted. Cfdump shows the proper form variables being passed. Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '#thisprojectid#', '#form["ProteinSequence" & LoopCount]#', '#form["genename" & LoopCount]#', '#form["NoAminoAcids" & LoopCount]#' ) On 10/26/2010 10:51 AM, Michael Grant wrote: > Could you post your code? > If you only loop a single time do you still get the error? > > On Tue, Oct 26, 2010 at 1:47 PM, Rick Colman wrote: > >> that did not work. >> >> what is funny is that the debug sql statement looks ok : >> >> Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) >> Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) >> >> On 10/26/2010 10:40 AM, Michael Grant wrote: >>> Maybe try this instead: >>> >>>Values( >>>'#thisprojectid#', >>>'#form["ProteinSequence"& LoopCount]#', >>>'#form["genename"& LoopCount]#', >>>'#form["NoAminoAcids"& LoopCount]#' >>>) >>> >>> >>> >> > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
1) can you expand on "did not work"? like provide the error message ;-) 2) I would assume the project ID is numeric and thus no need for the single quotes around '#thisprojectid#' (same goes for count) HTH Cheers On Tue, 2010-10-26 at 10:47 -0700, Rick Colman wrote: > that did not work. > > what is funny is that the debug sql statement looks ok : > > Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) > Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) > > On 10/26/2010 10:40 AM, Michael Grant wrote: > > Maybe try this instead: > > > > Values( > > '#thisprojectid#', > > '#form["ProteinSequence"& LoopCount]#', > > '#form["genename"& LoopCount]#', > > '#form["NoAminoAcids"& LoopCount]#' > > ) > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
1) send the real code to avoid all the "gee that's missing" crap ;-) 2) I have never seen CFQUERYPARAM used in the SELECT clause before...only ever the WHERE clause So to me that is odddoesn't mean it's not OK Cheers On Tue, 2010-10-26 at 12:21 -0500, Matt Quackenbush wrote: > Okay, I cannot for the life of me figure this one out. This is essentially > a basic CF insert... > > > insert into foo (field,list) >select >, >othertable.field >from >othertable >where >othertable.otherfield = > ; > select scope_identity() as newID from foo; > > > > And the result is a big fat "TMP is undefined" exception being thrown. > > This code is being run on CF 8.0.1 against SQL Server 2003. The exact same > code works flawlessly on CF9.0.1 against SQL Server 2008. > > Any ideas? > > Thanks in advance. > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
On Tue, Oct 26, 2010 at 1:40 PM, Matt Quackenbush wrote: You sure it's finding a value to insert from other table? And this query variable name is unique? other then that, I always use output inserted.fieldNames as it's one statement instead of two. insert into foo (field,list) OUTPUT inserted.FieldName select , othertable.field from othertable where othertable.otherfield = ; select scope_identity() as newID from foo; ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
Could you post your code? If you only loop a single time do you still get the error? On Tue, Oct 26, 2010 at 1:47 PM, Rick Colman wrote: > > that did not work. > > what is funny is that the debug sql statement looks ok : > > Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) > Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) > > On 10/26/2010 10:40 AM, Michael Grant wrote: > > Maybe try this instead: > > > > Values( > > '#thisprojectid#', > > '#form["ProteinSequence"& LoopCount]#', > > '#form["genename"& LoopCount]#', > > '#form["NoAminoAcids"& LoopCount]#' > > ) > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
that did not work. what is funny is that the debug sql statement looks ok : Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) On 10/26/2010 10:40 AM, Michael Grant wrote: > Maybe try this instead: > > Values( > '#thisprojectid#', > '#form["ProteinSequence"& LoopCount]#', > '#form["genename"& LoopCount]#', > '#form["NoAminoAcids"& LoopCount]#' > ) > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Ugh indeed. Do you take a drawing of your car to the mechanic when you have a problem? On Tue, Oct 26, 2010 at 1:40 PM, Matt Quackenbush wrote: > > Ugh. It was pseudo code. > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping through an insert statement
Maybe try this instead: Values( '#thisprojectid#', '#form["ProteinSequence" & LoopCount]#', '#form["genename" & LoopCount]#', '#form["NoAminoAcids" & LoopCount]#' ) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Ugh. It was pseudo code. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
I don't see where you define your datasource. On Tue, Oct 26, 2010 at 1:31 PM, Matt Quackenbush wrote: > > Oh, and yes, I can run the identical query in the SQL Server Management > Studio without any troubles at all. > > I am at a loss on what could cause this behavior. > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
looping through an insert statement
Is this the correct syntax for looping through an insert: Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '#thisprojectid#', '#form['ProteinSequence' & LoopCount]#', '#form['genename' & LoopCount]#', '#form['NoAminoAcids' & LoopCount]#' ) I am getting an error when I know the form field name is correct: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'ProteinSequence'. The error occurred in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: line 77* 75 : '#form['ProteinSequence'& LoopCount]#', 76 : '#form['genename'& LoopCount]#', *77 : '#form['NoAminoAcids'& LoopCount]#'* 78 : ) 79 : Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Oh, and yes, I can run the identical query in the SQL Server Management Studio without any troubles at all. I am at a loss on what could cause this behavior. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query Var Disappears
Errr... SQL Server 2005, not 2003. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Query Var Disappears
Okay, I cannot for the life of me figure this one out. This is essentially a basic CF insert... insert into foo (field,list) select , othertable.field from othertable where othertable.otherfield = ; select scope_identity() as newID from foo; And the result is a big fat "TMP is undefined" exception being thrown. This code is being run on CF 8.0.1 against SQL Server 2003. The exact same code works flawlessly on CF9.0.1 against SQL Server 2008. Any ideas? Thanks in advance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 'e-commerce' product catalogue
Jonah- I'm interested to check our your product when it's release. Is there a way to be notified? Andrew >I don't know any free ones. We're about to release a new CF based >ecommerce engine in the next few weeks though. > >Thanks, >.jonah > >On 10/25/10 11:37 AM, Stephane Vantroyen wrote: >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 'e-commerce' product catalogue
Hi Russ, I was asking Jonah about his product specifically. Thanks though for posting. On Tue, Oct 26, 2010 at 11:40 AM, Russ Michaels wrote: > > There is of course paypal which has buyitnow buttons, but I would look at > wordpress or something for a quick easy n free solution > > On 26 Oct 2010 00:28, "Michael Grant" wrote: > > > With support for which merchant services? > > > On Mon, Oct 25, 2010 at 5:26 PM, .jonah wrote: > > > > > I don't know any free on... > Archive: > http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338531 > > Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm > Unsubscribe: http://www.hous... > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 'e-commerce' product catalogue
There is of course paypal which has buyitnow buttons, but I would look at wordpress or something for a quick easy n free solution On 26 Oct 2010 00:28, "Michael Grant" wrote: With support for which merchant services? On Mon, Oct 25, 2010 at 5:26 PM, .jonah wrote: > > I don't know any free on... Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.hous... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamically resizing a cfwindow?
Wait a second. Is that actually a window or is this a modal "window" ? If it's the latter than none of the advice I gave is going to work since it's all for targeting an actual window. On Tue, Oct 26, 2010 at 9:32 AM, Brook Davies wrote: > > If you use firefox and firebug, turn on the inspection option in firebug > and > roll your mouse over the upper left corner of the window. You should be > able > to find the windows containing div, it should look something like this: > > class="x-window-tr">... > > > Find the ID of the containing div and in the firebug console type > Ext.getCmp('window-id'). This will dump all of the windows methods and > properties, look through it for the method you need and try calling it > directly via the console (eg. Ext.getCmp('window-id').setPosition(x,y) > > Now, I have never used Coldfusions Ext implementation, and this is only how > I would do it with the standalone Ext library. I don't know if it will work > the same. I assume that the Ext namespace exists and can be used like this? > But I could be wrong... > > Brook > > -Original Message- > From: Andrew Scott [mailto:andr...@andyscott.id.au] > Sent: October-25-10 7:28 PM > To: cf-talk > Subject: RE: Dynamically resizing a cfwindow? > > > Which version of ColdFusion are you trying this on? > > Regards, > Andrew Scott > http://www.andyscott.id.au/ > > > -Original Message- > > From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] > > Sent: Tuesday, 26 October 2010 12:38 PM > > To: cf-talk > > Subject: Re: Dynamically resizing a cfwindow? > > > > > > Not sure if I follow. Put the code in the parent window? I tried that, > works in > > IE, doesn't work in Chrome. > > > > The interesting thing is that when I launch the cfwindow using IE (I > normally > > use Chrome), it resizes the parent window, but not the cfwindow (even > > though the this.resizeTo() code is in the page loaded within the > cfwindow). > > > > Pete > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Dynamically resizing a cfwindow?
If you use firefox and firebug, turn on the inspection option in firebug and roll your mouse over the upper left corner of the window. You should be able to find the windows containing div, it should look something like this: ... Find the ID of the containing div and in the firebug console type Ext.getCmp('window-id'). This will dump all of the windows methods and properties, look through it for the method you need and try calling it directly via the console (eg. Ext.getCmp('window-id').setPosition(x,y) Now, I have never used Coldfusions Ext implementation, and this is only how I would do it with the standalone Ext library. I don't know if it will work the same. I assume that the Ext namespace exists and can be used like this? But I could be wrong... Brook -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: October-25-10 7:28 PM To: cf-talk Subject: RE: Dynamically resizing a cfwindow? Which version of ColdFusion are you trying this on? Regards, Andrew Scott http://www.andyscott.id.au/ > -Original Message- > From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] > Sent: Tuesday, 26 October 2010 12:38 PM > To: cf-talk > Subject: Re: Dynamically resizing a cfwindow? > > > Not sure if I follow. Put the code in the parent window? I tried that, works in > IE, doesn't work in Chrome. > > The interesting thing is that when I launch the cfwindow using IE (I normally > use Chrome), it resizes the parent window, but not the cfwindow (even > though the this.resizeTo() code is in the page loaded within the cfwindow). > > Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 'e-commerce' product catalogue
Plenty of free php solutions out there and very good ones. Cf is not the best solution when looking for free solutions. Site director is not free but not expensive and very good. On 25 Oct 2010 19:45, "Stephane Vantroyen" wrote: Hi, I know this question has certainly been asked many times before, but does anyone know a good free CF 'e-commerce' product catalogue? I've searched on riaforge but didn't find anything alike? Thanks, Stephan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm