L
Larry_Milner
I've started to hit the wall with DRW being able to meet my rerequirements.
Until now I've avoided digging in and fear the code requirement under ASP to
make Database select/insert/modify/delete statement.
I do understand SQL and some fundamentals of the ASP code that wraps around
results.
Where can I go to look at samples (snippets) or an end to end example set on
connecting to a database already set up as a SYSTEM DSN?
I've done some searches and poked around a bit and not seeing a simple
approach to grabbing hold of the horns.
I thought there used to be 'pinned' references to sites that featured
exactly this type of information in this forum but not seeing anything like
that at this time.
The issue that put me over the top was DRW allowing information to be
inserted such as an email address, but not allowing me to do a
SELECT COUNT(*) as COUNT FROM users WHERE (email_addr = '::email_addr::')
Seems you can hardcode (email_addr='(e-mail address removed)') the request and DRW
will return a match. But if you pass the parameter from a form DRW isn't
able to find the same match the hardcode provided.
Any help would or direction where to start would be appreciated.
Until now I've avoided digging in and fear the code requirement under ASP to
make Database select/insert/modify/delete statement.
I do understand SQL and some fundamentals of the ASP code that wraps around
results.
Where can I go to look at samples (snippets) or an end to end example set on
connecting to a database already set up as a SYSTEM DSN?
I've done some searches and poked around a bit and not seeing a simple
approach to grabbing hold of the horns.
I thought there used to be 'pinned' references to sites that featured
exactly this type of information in this forum but not seeing anything like
that at this time.
The issue that put me over the top was DRW allowing information to be
inserted such as an email address, but not allowing me to do a
SELECT COUNT(*) as COUNT FROM users WHERE (email_addr = '::email_addr::')
Seems you can hardcode (email_addr='(e-mail address removed)') the request and DRW
will return a match. But if you pass the parameter from a form DRW isn't
able to find the same match the hardcode provided.
Any help would or direction where to start would be appreciated.