Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: anon47
  • Order by date
  1. anon47

    Syntax Error

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

    Syntax Error

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

    How do spammers know...?

    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/
  4. anon47

    Syntax Error

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

    Auto ID

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

    Auto ID

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

    Auto ID

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

    Auto ID

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

    Auto ID

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

    Auto ID

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

    Auto ID

    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!
  12. anon47

    Auto ID

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

    Auto ID

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

    Error on Page

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

    Error Pages On 7.0 IIS

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

    Error Pages On 7.0 IIS

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

    Error on Page

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

    Error on Page

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

    Error on Page

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

    Error on Page

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

Part and Inventory Search

Back
Top