|
|
Forum Newbie
Group: Forum Members Last Login: 10/10/2011 8:36:28 PM Posts: 5, Visits: 1
|
|
Gucci Handbags
Gucci Handbags Sale
Gucci Handbags Cheap
Gucci Handbags Outlet
Gucci Card Cases
Gucci Clutches
Gucci Coin Purses
Gucci Continental
Gucci Exotics
Gucci Flap French
Gucci Hobos
Gucci Messenger Bags
Gucci Mini Wallets
Gucci Shoulder Bags
Gucci Top Handles
Gucci Totes
Gucci Zip Around
|
|
|
|
Forum Newbie
Group: Forum Members Last Login: 10/27/2010 8:48:37 AM Posts: 2, Visits: 3
|
|
|
|
|
Junior Member
Group: Forum Members Last Login: 4/16/2009 2:08:02 PM Posts: 11, Visits: 133
|
|
i learned how to do a few things
carman most
|
|
|
|
Junior Member
Group: Forum Members Last Login: 4/13/2009 7:35:58 PM Posts: 14, Visits: 3
|
|
Validate all input with regular expressions before writing the data to tables. |
|
|
|
Forum Newbie
Group: Forum Members Last Login: 4/3/2009 2:51:19 PM Posts: 9, Visits: 2
|
|
Look for email validation REGEXes - they're far more accurate than just checking for an @ sign and a . after it. |
|
|
|
Junior Member
Group: Forum Members Last Login: 4/2/2009 5:42:10 PM Posts: 10, Visits: 2
|
|
|
|
|
Admin
Group: Administrators Last Login: 4/27/2009 7:34:30 AM Posts: 46, Visits: 52
|
|
Hopefully this will help you out a little. This indicates if there is any '_' after the @.
WHERE ((SELECT CHARINDEX(, emailaddress) +1 ) > (SELECT CHARINDEX(, emailaddress, (SELECT CHARINDEX(, emailaddress)))))
|
|
|
|
Forum Newbie
Group: Forum Members Last Login: 8/28/2008 9:56:22 AM Posts: 1, Visits: 3
|
|
Writing an email validation code using select, where, or and like statements. Something like this:
select emailaddress from contact where ((emailaddress = ''
-This looks for entries where email was left blank
I am having trouble making the code to make sure "_" does no appear after "@". If anyone can help me out, thanks.
|
|
|
|