No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
8 Posted Topics
What database are you using?
Nearly, should be... If rs("distance")<=25 Then Exit For ...for less than or equal to. :o)
By getting the knowledge to do so. Check out this site with these two links, the basics are there... [URL="http://www.w3schools.com/asp/default.asp"]http://www.w3schools.com/asp/default.asp[/URL] [URL="http://www.w3schools.com/ado/default.asp"]http://www.w3schools.com/ado/default.asp[/URL] Good luck ;o)
Check out this site :: [URL="http://2enetworx.com/dev/samples/memwhoson.asp"]http://2enetworx.com/dev/samples/memwhoson.asp[/URL] :: that should help you out.
Would it not be more convenient to simply have a field in your user table that declares what type of user the user is? ie. Fieldname = UserType Value = Prospect / Customer But you could just as easily fire an insert command against the 1st table into the customer …
Need to slightly alter your code from what you have to read as follows... [code=ASP]<td><a href="U_ViewTransDet.asp?id=<%=rs("Field_Id")%>">Name of link</a></td>[/code] Hope that helps, Rob. <snipped>
Can't be done with Access I'm afraid, you could cheat however and create a routine that runs whenever someone firsts visits your site, it could check the date against the database and another field eg, EmailSent, if that is false, then send the email and flag to true. That way, …
When you login, create a session variable, eg. Session("LoggedIn") = "True" ...then apply an IF statement around your Login link based on this variable, eg. [code=ASP]<% If Session("LoggedIn") <> "True" %> <a href="login.asp">Login</a> <% End If %>[/code] Rob <snipped>
The End.