Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Database > Microsoft SQL Server
Reload this Page

Asp/ado

Discuss Asp/ado in the Microsoft SQL Server forum on ASP Free.
Asp/ado Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old May 28th, 2004, 11:05 AM
Big Blue Ragu Big Blue Ragu is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: May 2004
Posts: 1 Big Blue Ragu User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy Asp/ado Newbe - Help Me Please!

I am a newbe to ASP and ADO. I am having a problem with an inner join SQL select statement.

This is the eror: Error Type:
Microsoft VBScript compilation (0x800A0409)
Unterminated string constant
/includes/navigation6.asp, line 10, column 58
strSQL = "SELECT dUserName, dAttributeType, dAttributeName

Here is the entire SQL statement

strSQL = "SELECT dUserName, dAttributeType, dAttributeName
FROM UserSecurityAttributes INNER JOIN
Users ON Users.dName = UserSecurityAttributes.dUserName
WHERE Users.dName = UserSecurityAttributes.dUserName AND Users.dEmail =" & "'" & currentPassword & "'"

Can anyone help me with this? It's driving me crazy.
Reply With Quote
  #2  
Old May 28th, 2004, 01:17 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
  
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 21 h 32 m 23 sec
Reputation Power: 180
VBScript in asp code is sensitive to line breaks unlike some other programming languages. I usually concatenate my string on multiple lines, or there is a line continuation &_ you can use
Code:
strSQL = "SELECT dUserName, dAttributeType, dAttributeName" 
strSQL = strSQL & " FROM UserSecurityAttributes INNER JOIN"
strSQL = strSQL & " Users ON Users.dName = UserSecurityAttributes.dUserName"
strSQL = strSQL & " WHERE Users.dName = UserSecurityAttributes.dUserName AND" strSQL = strSQL & " Users.dEmail =" & "'" & currentPassword & "'"
__________________
======
Doug G
======
I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
Reply With Quote
  #3  
Old May 28th, 2004, 01:20 PM
Memnoch's Avatar
Memnoch Memnoch is offline
Unholy Moderator
ASP Free God 14th Plane (11500 - 11999 posts)
  
Join Date: Oct 2003
Location: In hell, where did you think?
Posts: 11,760 Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 3 Weeks 5 Days 5 h 22 m 16 sec
Reputation Power: 443
try this
Code:
strSql = "SELECT A.dUsername, A.dAttribute, A.dAttributeName FROM UserSecurityAttributes As A INNER JOIN [Users] As B On (A.dUserName = B.dName) WHERE A.dEmail = '" & currentPassword & "'"


Foreign keys should have the same name as the Primary key it is referencing (A.dUsername = B.dUsername), it makes it easier to see and understand that a relationship exists between the two tables.
Reply With Quote
Reply

Viewing: ASP Free Forums > Database > Microsoft SQL Server > Asp/ado

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway.