Thanks all for the help :O) Ade
-----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 14 March 2003 16:10 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Accessing FORM structure perhaps look at myQuery.recordcount and then if the iteration is greater than this then stop etc? > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 14 March 2003 16:13 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Accessing FORM structure > > > Sorry, I sure have made it more clear, I'm developing on MX > and it's going > to CF5. > > I don't think the issue you've mentioned is the same thing, > > "Building dynamic queries with queryAddRow() and queryAddColumn() can > generate a blank error message when a variable number of column/row > combinations is reached." > > By "blank error message" I think they mean it's one of those > unhelpful error > messages that don't show any info. > > I only used the queryAddRow() function to demonstrate what > was happening, it > still happens with a record set passed back via cfprocresult. > > Either way, I need to use different code. I need to do a check on the > variable before outputting it. I've tried > > IsDefined("qHDMNames.Name[#i#]") > > and various uses of DE within it but I cannot seem to get it > right. Does > anyone have any ideas on this? I'm close to using > cftry/cfcatch but that's > gonna make for messy code. > > Cheers for your help so far. > > Ade > > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 14 March 2003 15:51 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Accessing FORM structure > > > ah - you asked about CF5 to start with so I tested that on CF5. > > Hang on, on CFMX (updater 2) I get no error, like you're getting. > > interesting. > > aha, its a known issue: > > http://www.macromedia.com/support/coldfusion/ts/documents/tn18325.htm > > issue: 48786 > > "Building dynamic queries with queryAddRow() and queryAddColumn() can > generate a blank error message when a variable number of column/row > combinations is reached." > > it doesn't appear to be addressed in updater 3 either. > > > > > -----Original Message----- > > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > > Sent: 14 March 2003 15:48 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] Accessing FORM structure > > > > > > What version of CF are you using, I'm on MX? > > > > -----Original Message----- > > From: Rich Wild [mailto:[EMAIL PROTECTED] > > Sent: 14 March 2003 15:39 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] Accessing FORM structure > > > > > > I get an error as expected. > > > > An error occurred while evaluating the expression: > > #myQuery.myColumn[2]# > > Error near line 56, column 26. > > > > as you sure you're not trapping the error somehow? > > > > > -----Original Message----- > > > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > > > Sent: 14 March 2003 15:44 > > > To: '[EMAIL PROTECTED]' > > > Subject: RE: [ cf-dev ] Accessing FORM structure > > > > > > > > > If anyone wants to see it in action try this code..... > > > > > > <cfset myQuery = QueryNew("myColumn")> > > > <cfset QueryAddRow( myQuery, 1 )> > > > <cfset QuerySetCell( myQuery, "myColumn", "some value" , 1 )> > > > > > > <cfdump var="#myQuery#"> > > > > > > <cfoutput> > > > Record Count: #myQuery.RecordCount#<br> > > > Row 1: #myQuery.myColumn[1]#<br> > > > Row 2: #myQuery.myColumn[2]#<br> > > > Row 3: #myQuery.myColumn[3]#<br> > > > </cfoutput> > > > > > > Ade > > > > > > -- > > > ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
