Re: Web DNA...
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 68922
interpreted = N
texte = This is exactly why I don't want to switch to php:Clint Davis wrote:> I usually put this into a func.php file that I include into each page. Note> the line breaks that should all be one line.> > if (!function_exists("GetSQLValueString")) {> function GetSQLValueString($theValue, $theType,(LINEBREAK)> $theDefinedValue = "", $theNotDefinedValue = "") {> $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;> $theValue = function_exists("mysql_real_escape_string") ?(LINEBREAK)> mysql_real_escape_string($theValue) : mysql_escape_string($theValue);> switch ($theType) {> case "text":> $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";> break; > case "long":> case "int":> $theValue = ($theValue != "") ? intval($theValue) : "NULL";> break;> case "double":> $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";> break;> case "date":> $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";> break;> case "defined":> $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;> break;> }> return $theValue;> }> }> ?>> > > Then, you can set your variables like this:> $myVariable = GetSQLValueString($_GET['Variable'],'text');> (your variable name) = GetSQLValueString(GET/POST depending ['Incoming> Variable Name'],'type of variable from function above');Frank-------------------------------------------------------------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:
This is exactly why I don't want to switch to php:Clint Davis wrote:> I usually put this into a func.php file that I include into each page. Note> the line breaks that should all be one line.> > if (!function_exists("GetSQLValueString")) {> function GetSQLValueString($theValue, $theType,(LINEBREAK)> $theDefinedValue = "", $theNotDefinedValue = "") {> $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;> $theValue = function_exists("mysql_real_escape_string") ?(LINEBREAK)> mysql_real_escape_string($theValue) : mysql_escape_string($theValue);> switch ($theType) {> case "text":> $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";> break; > case "long":> case "int":> $theValue = ($theValue != "") ? intval($theValue) : "NULL";> break;> case "double":> $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";> break;> case "date":> $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";> break;> case "defined":> $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;> break;> }> return $theValue;> }> }> ?>> > > Then, you can set your variables like this:> $myVariable = GetSQLValueString($_GET['Variable'],'text');> (your variable name) = GetSQLValueString(GET/POST depending ['Incoming> Variable Name'],'type of variable from function above');Frank-------------------------------------------------------------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/
Frank Nordberg
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:
argh must send var to iframe to load webDNA search (2003)
Setting a range in a search (1998)
strange problem listfiles and movefile (long) (2000)
Deleting duplicates from a db (2000)
Problems with [Applescript] (1997)
small hairball -- stuck on [showif] for related db (1998)
Problems with [Applescript] (1997)
emailer w/F2 (1997)
Temp DBs (2007)
[WebDNA] Nginx (2010)
emailer (1997)
WC TableGrinder (1997)
WCS Newbie question (1997)
Garbage files created -METOO (2000)
% (mod) was looping table rows (1999)
Hide Ifs (2000)
Deleting Orders (1997)
How to include weather (2000)
[BULK] [WebDNA] [BULK] Console / WebDNA no connection to module (2011)
creating a ShipCosts database (1997)