- see footer for list info -<
Hi all,
how do you insert an encrypted string into a database?
Example:
<cfquery name="ins1" datasource="#request.dsn#"
password="#request.pwd#">
INSERT INTO tbl_example
(name,dob)
VALUES
('#encrypt(name,"12345")#','#encrypt(dob,"12345")#')
</cfquery>
The encrypted strings cause a problem with the db query because of the
charaters that are outputted. IE. the above query goes through like this:
INSERT INTO tbl_example (name,dob) VALUES ('%;E:0MOP ','(# O1[ZQBUO< ')
Thanks, Damien
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
