Kanati,
It would be cool to support parameterized queries.
Just think no concatinating to build up your big bad query.
8)
It's so nice to be able to set the parameters and run the query like:
BD_SetParm("DBAcct",AlphaType)="0000007"
BD_SetParm("DBAge",NumericType)="12"
t=BD_SQLQuery("select * from accounts where account=<%DBAcct|'0000000'%> and age> <%DBAge|10%>")
All you have to do is parse for <% %>, and plug in the value for parameter,
if none is provided use the default value of zeros in this case. SQL becomes:
select * from accounts where account='0000007' and age>12
<%DBAcct|'0000000'%>
shows parm name | default value
Just thought I'd get my LAST request in.
8)
It would be cool to support parameterized queries.
Just think no concatinating to build up your big bad query.
8)
It's so nice to be able to set the parameters and run the query like:
BD_SetParm("DBAcct",AlphaType)="0000007"
BD_SetParm("DBAge",NumericType)="12"
t=BD_SQLQuery("select * from accounts where account=<%DBAcct|'0000000'%> and age> <%DBAge|10%>")
All you have to do is parse for <% %>, and plug in the value for parameter,
if none is provided use the default value of zeros in this case. SQL becomes:
select * from accounts where account='0000007' and age>12
<%DBAcct|'0000000'%>
shows parm name | default value
Just thought I'd get my LAST request in.
8)