Search results for query: *

It always returns: HTTP 500 - Internal server error I'm checking with my host provider to see if anything is messed up with my folder securities at this time.. Thanks, Bri

Thanks. That makes total sense. I have altered the information to the following, but it fails the minute I allow it to read the &quot;conn.Execute locSQL&quot; line.. Any ideas?? Here's what I've got now: <% ' ================================= ' = DATABASE CONNECTION '...

OK. Now I'm stumped. No matter how I set it up, it fails. Here is what I've got: <% ' ================================ ' = CONSTANTS ' ================================ 'Const adOpenForwardOnly = 0 'Const adOpenDynamic = 2 'Const adLockReadOnly = 1 'Const adLockPessimistic = 2 Const...

Excellent.. Thanks for the advice. Bri

OK. Now I feel stupid. This is all it turned out to be: Original: sql = &quot;select * from PTJobs where location = &quot; & Request.Form(&quot;Query&quot;) Fix: sql = &quot;select * from PTJobs where location = &quot; & &quot;'&quot; & Request.Form(&quot;Query&quot;) & &quot;'&quot; The...

I've tried the suggestions and still can't figure out why I'm not getting an appropriate response when the SQL query results in zero records. I'm stumped.... This is the first time I've ever tried to utilize the query functionality. Usually, I've simply displayed the data, but that will not work...

I'm trying to recognize an SQL query that results in no available records from the recordset. When I enter a value that I know is not in the record set, I keep getting &quot;There is a problem with the page you are trying to reach and it cannot be displayed.&quot; When I enter a value known to...