Search results for query: *

I was wrong here is the code that works: sql = "SELECT * FROM [Clients] WHERE [Clients].[Email]='" &Trim(Request.Form("Email"))&"' " rs.open sql, conn If rs.EOF Then Else If Trim(Request.Form("Email"))=Trim(rs("Email")) Then Response.Write "<p><font size=6 ><b>Error</b></p><p><font size=3>No...

Never mind I think I did something to the email field on the server so I deleted the field and recreated it and it works perfect .

OK guys here is the link to the filter that we use and its free donate if you like it. Also it SMTP based and filters spam for ever email account! GREAT Product http://www.martijnjongen.com/site/

Below is the code I use to check to see if there has been and email associated with a companies account if so it gives them and error to enter another email. It works great however if the person has a number in there email such as abc123@abc.com it does not notice the email even if its in the...

Hey Philhedg How do I insert a record before accepting input?

Agree with you so here is what I have: sql = "SELECT *, (Select SCOPE_IDENTITY() From Clients) AS ClientID FROM [Clients]" rs.open sql, conn, 3, 3 session("myvar16")=rs("ClientID") rs.Update rs.Close Here is the error I am getting: Microsoft SQL Native Client error '80004005'...

NO I looked at it just working on trying this method. I have it like this but its not displaying the results, or is this not the way to use it? sql = "SELECT*,('SELECT max(id)+1') AS maxid FROM [Clients]" rs.open sql, conn, 3, 3 session("myvar16")=rs("maxid") rs.Close

I am out of it now but it gave a can't use quotations in string error or something like that. I am trying to figer how to use the max(id) method but no dice at this point

LOL Philhege now that’s funny! Far as the uniqueness of the email. Only at signup is the email used to find the user ID and our type of service business there should only be one business with that email signing up. The blah'; Drop Table Clients; gives an error hints not letting the user...

Ok guys, here is my work around for this: After adding the new record on signup I close the conn string then run the following code that reopens the table and (since no two email address are the same I bound it by the email address used at signup which is required field) gets the id. If anyone...

Ok I am confused, so here is the code I am using: sql = "SELECT * FROM [Clients]" rs.open sql, conn, 3, 3 session("myvar1")=rs("ClientID") rs.Update rs.Close How can I get it to return the auto ID? Thanks again all!

Thanks guys. philhege how would I do that? I don't really want to select max(id) + 1 because if you have two simultaneous signups this could create a problem.

IN access when you start typing a value in say the Name Field the system generates an auto id while you’re in the record. In SQL however it makes you wait until the editing is done. Is there any way to change the way SQL handles this so that you know what the auto id is before you finish the...

I got it here is the fix by default the IIS 7.0 turns the send error to browser function off. Run this command: %windir%\system32\inetsrv\appcmd set config -section:asp -scriptErrorSentToBrowser:true or go to your UI under asp properties and set the "send error to browser" = True Later and...

I got it here is the fix by default the IIS 7.0 turns the send error to browser function off. Run this command: %windir%\system32\inetsrv\appcmd set config -section:asp -scriptErrorSentToBrowser:true or go to your UI under asp properties and set the "send error to browser" = True Later and...

I caused this error on our development server because I wanted to see how and what information would be given regarding such an error. This is what it gave: "An error occurred on the server when processing the URL. Please contact the system administrator" I need it to be something like this...

Can't get the custom error to work right. This is IIS 7.0 to.

Thanks Sheco The operating system for the development server visa and win 2003 on the main server. I have the errors set to details but it still shows the same error with no information. Frustrating because the other server does it automaticly and I do hae the browser show friendly errors un...

This is what it looks like on the server and how I needed to to do on the development server so I can track errors. Any help would be great Microsoft VBScript compilation error '800a0401' Expected end of statement /clients/test/index.asp, line 18...

I caused this error on our development server because I wanted to see how and what information would be given regarding such an error. This is what it gave: An error occurred on the server when processing the URL. Please contact the system administrator On our server it doesn't do that, it...