my bad, sorry I had 15 things going on when I posted that.
let me be a bit more detailed this time.
I currently do have some single page forms that I use this code to capture the
IP Address:
<cfset ipaddress="#cgi.remote_addr#">
<cfset IPArray = listToArray(IPAddress,".")>
<cfset IPNumber= (IPArray[1] * (256)^3) + (IPArray[2] * (256)^2) + (IPArray[3]
* 256) + IPArray[4]>
I placed that same code into my form on my cart and since my database won't
accept "cgi.remote_addr" as a field name, I named the fied name in the database
"ipaddress".
I then added this code on my processing form:
INSERT INTO orders (ipaddress, IDname, CCFname, CCLname,
CCcompany,CCStreet1,CCStreet2,CCcity,CCstate,CCzip,Phone,Fax,Email,CCNumber,CCtype,CCexp,CCVC,shipFname,
shipLname,
shipcompany,shipStreet1,shipStreet2,shipcity,shipstate,shipzip,specialinstructions,
orderdate, cleared, salestax, Shippingmethod, ShippingCost)
VALUES (
<cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="#cgi.remote_addr#">,
The problem I'm having is that on our end where we retrieve the order info, the
ipaddres feild is showing our IP instead of the clients and for some reason is
showing the clients IP in another field that is designated for the clients ID
code.
In fact, it shows their IP and then their code and then their IP twice after
that.
so, I'm not sure what I've done wrong.
any thoughts
and thanks for your quick response
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275182
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
