Pascal
> -----Original Message-----
> From: Brant Winter [mailto:[EMAIL PROTECTED]
> Sent: 09 September 2004 07:25
> To: CF-Talk
> Subject: concatenate a string
>
> Can some please tell me how to concatenate a string on CF ?
>
>
>
> <cfquery datasource="obscript" name="qGetDrugs" maxrows="10">
>
> SELECT
SDISPDATE,PTITLE,PFIRSTNAME,PSURNAME,PMEDICARE,SDRUGDESC,SQTY,SRXNO
> from scripts
>
> ORDER BY PSURNAME DESC,PMEDICARE DESC
>
> </cfquery>
>
>
>
> <cfset scriptNO = 1>
>
>
>
> <cfset scriptrun=StructNew()>
>
> <cfset scriptrun.SCRIPT&#scriptNO#=StructNew()>
*********
> This is the string I need to look like ->
> scriptrun.script1=StructNew(),scriptrun.script2=StructNew(), etc etc
> *************
>
>
>
> <cfloop query="qGetDrugs">
>
>
>
> <cfif StructCount(scriptrun.SCRIPT#scriptNO#)
LTE
> 3>
>
> <cfset
> scriptrun.SCRIPT#scriptNO#.SDRUGDESC = #qGetDrugs.SDRUGDESC#> *****
These
> two lines need fixing too **********
>
> <cfset
> scriptrun.SCRIPT#scriptNO#.SRXNO
> = #qGetDrugs.SRXNO#>
>
> </cfif>
>
> <cfset scriptNO = scriptNO + 1>
>
>
>
> </cfloop>
>
>
>
> <cfdump var="#variables#">
>
>
>
> ----------------------------------------------------------------
> The information transmitted is intended only for the person or entity
to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of,
or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you
received
> this in error, please contact the sender and delete the material from
any
> computer. It is the responsibility of the recipient to ensure that the
> onward transmission, opening or use of this message and any
attachments
> will not adversely affect its systems or data. Please carry out such
virus
> and other checks, as you consider appropriate. To the fullest extent
> allowed by law, no responsibility is accepted by Haematology &
Oncology
> Clinics of Australasia for any virus damage caused by this message.
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
