on 11/29/00 6:28 PM, Bud at [EMAIL PROTECTED] wrote:
>> '#required1#'<cfif isdefined('author2')>, <cfelse> </cfif>
>>
>> <cfif isdefined('author2')>
>> '#author2#',
>> </cfif>
>>
>> <cfif isdefined('title_price2')>
>> '#title_price2#',
>> </cfif>
>
> Take a peek at this. If author2 is not defined, and anything after it
> is, required1 and the next field will not have a comma separating
> them.
Try something like:
'#required1#'
<cfif isdefined('author2')>
,'#author2#'
</cfif>
<cfif isdefined('title_price2')>
,'#title_price2#'
</cfif>
By putting the commas in front of the optional column names you can avoid
problems like this.
--
Rob Keniger
big bang solutions
<mailto:[EMAIL PROTECTED]>
<http://www.bigbang.net.au>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
