hai everybody
this is customtag related problem. i am trying to insert values from
attributes. so i have written following code.
here 1 st question is can i use loop with in the insert command? and
when u r passing the value can i check the condition whether
attributes.field_char#i# is char or numeric. (here 0 means numeric, > 0 is
char)
based on that one i am filtering with cfif condition.
but problem is while executing error is coming. that error i am pasting here
here we can use any alternative way to run this one.
<cfquery name="queryac" datasource="#attributes.datasource#">
Insert into #ATTRIBUTES.tablename#
<cfloop from ="1" to ="#ln#" index="i">
(#evaluate("ATTRIBUTES.field#i#")#)
VALUES(
<cfif #Evaluate("attributes.field_char#i#")# EQ "0">
#FORM.txta#i#,
<cfelse>
'#FORM.txta#i#',
</cfif>
)
</cfloop>
</cfquery>
ERROR here:
Error Diagnostic Information
Just in time compilation error
Invalid parser construct found on line 9 at position 17. ColdFusion was
looking at the following text:
,
Invalid expression format. The usual cause is an error in the expression
structure.
The last successfully parsed CFML construct was dynamic text (a CFML
expression) occupying document position (9:4) to (9:14).
The specific sequence of files included or processed is:
C:\INETPUB\WWWROOT\CUSTOMTAGS\LISTADDF.CFM
C:\CFUSION\CUSTOMTAGS\LISTADD.CFM Custom Tag
The error occurred while processing an element with a general identifier
of (CFMODULE), occupying document position (4:3) to (29:5) in the template
file C:\InetPub\wwwroot \customtags\listaddf.cfm.
Date/Time: 05/25/00 11:33:20
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
Remote Address: 127.0.0.1
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.