have a look at the evaluate() function, can't remember the exact syntax off
the top of my head but something like:
#evaluate("#name#")#
Steve Robson
-----Original Message-----
From: Mark Jones [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2000 14:52
To: '[EMAIL PROTECTED]'
Subject: query problem
I have a form variable name in a variable, i.e. name=form.<somename>. I
then want to get the value of that form variable out so that it can be
inserted into a query. So for instance I want to say
INSERT INTO <SomeTable>
(<Value1>, <Value2>)
VALUES('#form.Value1#', '<The variable name>')
Does anyone know how I reference the variable name. What I seem to want is
double pound signs around name and that does not work.
For instance to get the text form.<somename> I would do #name# so to get
the value of form.<somename> I would have to do ##name##.
Please help.
Thanks in advance,
Mark Jones
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
