Re: Note on MySQL Encrypt/Decrypt
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 60809
interpreted = N
texte = Hey Christian,Just thought I'd mention that another good place for tips like this would bein the interactive docs.http://webdna.smithmicro.com/ref/index.tplDonovanChristian F. Gurney wrote:> A brief note on using encryption functions with WebDNA and mySQL. It's not> immediately obvious in the mySQL docs how to decrypt a column within the> WebDNA setting. Or at least, it wasn't to me.;-) > > Here is a simple code example that brings back all of the columns for a> table, including an AES encrypted column and actually works:> > [SQLExecute conn_ref=conn1&result_var=rs1]> > SELECT *,AES_DECRYPT({column_name},'{key}') AS {new_name} FROM {table_name}> WHERE {column_name} = {value};> > [/SQLExecute]> > Everything within '{}' must be replaced with the appropriate element.> > The key finding is that you need to bring back the data with a column name> you assign with the 'AS' clause.> > Being relatively new to mySQL, I would certainly appreciate any tips or> amendments to this code from those more experienced.> > Christian F. Gurney> Managing Director> KG InterDev, LLC> cfgurney@kginterdev.com-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hey Christian,Just thought I'd mention that another good place for tips like this would bein the interactive docs.http://webdna.smithmicro.com/ref/index.tplDonovanChristian F. Gurney wrote:> A brief note on using encryption functions with WebDNA and mySQL. It's not> immediately obvious in the mySQL docs how to decrypt a column within the> WebDNA setting. Or at least, it wasn't to me.;-) > > Here is a simple code example that brings back all of the columns for a> table, including an AES encrypted column and actually works:> > [SQLExecute conn_ref=conn1&result_var=rs1]> > SELECT *,AES_DECRYPT({column_name},'{key}') AS {new_name} FROM {table_name}> WHERE {column_name} = {value};> > [/SQLExecute]> > Everything within '{}' must be replaced with the appropriate element.> > The key finding is that you need to bring back the data with a column name> you assign with the 'AS' clause.> > Being relatively new to mySQL, I would certainly appreciate any tips or> amendments to this code from those more experienced.> > Christian F. Gurney> Managing Director> KG InterDev, LLC> cfgurney@kginterdev.com-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Donovan Brooke
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[BoldWords] WebCat.acgib15Mac (1997)
Active Server Code... (1998)
Cart Number sequence (1997)
RE: combining strings (1997)
&FieldNametype=time unnecessary? (2000)
External Images (1998)
A little help on e-mail (HELP!!! :-) ) (1998)
Frames and WebCat (1997)
testing webcat 4 (2001)
Version f1 status (1997)
[taxrate] question (1997)
[WebDNA] Privat IP website behind a public IP website (2014)
Firesite cache vs webcat cache (1997)
Welcome Back (was) Newbie Question (1999)
First postarg not taking in $Commands (1997)
Webstar 1.3.1 PPC (1997)
email program problem (1998)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Country & Ship-to address & other fields ? (1997)
Speed Test Results Dell 2650 Xeon 2.4ghz (2002)