Very Interesting.
Maybe one of the Gurus here can enlighten us. I have used the Attribute
variables in many SQL queries. Here is an example query I use:
SELECT AssetName, ...
FROM Asset
WHERE AssetID = #ATTRIBUTES.AssetID#
AssetID is a select box value in the previous form. This query has never
given me a problem.
Russel
============================================================
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
Some days you eat the bear; some days the bear eats you.
============================================================
> -----Original Message-----
> From: Maia, Eric [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 31, 2001 13:21
> To: CF-Talk
> Subject: RE: String to Int
>
>
> I think this server is running ColdFusion 4.5.1, and it's accessing SQL
> Server 7. I don't have any problem with Attributes variables within
> ColdFusion, but they seem to be typed as a string when I try to
> insert them
> into the database or use them in a WHERE clause in a query.
>
> -----Original Message-----
> From: Russel Madere [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 31, 2001 6:42 AM
> To: CF-Talk
> Subject: RE: String to Int
>
>
> Strange!
>
> which version of Cold Fusion are you using? I have been using
> FormURL2Attributes.cfm for a while without any problems.
>
> Russel
>
> ============================================================
> Russel Madere, Jr. Senior Web Developer
> ICQ: 5446158 http://www.TurboSquid.com
>
> Some days you eat the bear; some days the bear eats you.
> ============================================================
>
>
> > -----Original Message-----
> > From: Maia, Eric [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 30, 2001 17:07
> > To: CF-Talk
> > Subject: RE: String to Int
> >
> >
> > I have had type errors related to Attributes. variables produced by
> > CF_FORMURL2ATTRIBUTES custom tag. I now use
> #Val(string_variable)# when I
> > know I'll need an integer (e.g. inserting into a numeric DB column).
> >
> > -----Original Message-----
> > From: Russel Madere [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 30, 2001 2:44 PM
> > To: CF-Talk
> > Subject: RE: String to Int
> >
> >
> > Actually, Cold Fusion does this automatically. Or more precisely, Cold
> > Fusion uses typeless variables. That way, you don't need to
> cast the type
> > for the variables.
> >
> > Russel
> >
> > ============================================================
> > Russel Madere, Jr. Senior Web Developer
> > ICQ: 5446158 http://www.TurboSquid.com
> >
> > Some days you eat the bear; some days the bear eats you.
> > ============================================================
> >
> >
> > > -----Original Message-----
> > > From: Richard Banks [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, January 30, 2001 15:53
> > > To: CF-Talk
> > > Subject: String to Int
> > >
> > >
> > > is there a way [ie. a cf function ]to convert a string to an
> > > integer. let's
> > > say a user enters the string '1976' , and i want to process
> > that string as
> > > the integer 1976.
> > > any help would be greatly appreciated. thanks
> > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
