Recent content by anon47

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...