| Author |
 Topic  |
|
|
DarrenLuxton
Junior Member
184 Posts |
 Posted - 17 June 2002 : 17:19:32
|
I've been having problems with my newsletter mod, i think it's got something to do with my running SQL, not sure, when i try and send an email, i get this error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Yes'.
/forum/nlEmail_List.asp, line 48
When i look at that line, i can see this.
strSQL_SelectEmail = "SELECT ID, Email FROM " & strTablePrefix & "MailList WHERE Active=Yes"
Any help???
Thanks
I'm running 3.3.05, running on IIS5, SQL2000 using ASPMAIL.
|
|
|
DarrenLuxton
Junior Member
184 Posts |
Posted - 18 June 2002 : 09:41:51
|
I was looking at the mod, and according to the readme, i'm running 1.2, does anyone know where i can get 2.0 from?
Thanks
|
 |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 11 September 2002 : 19:01:34
|
| I am having this exact problem....any takers? |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 11 September 2002 : 19:20:52
|
You need to replace the yes with a 1 in the code. Hey David, is anyone updating this thing? I did a little work so I could use it but didn't want to step on any toes and jump the gun.
wes |
|
|
| |
Topic |
|
Topic Locked
