two word tablename in sql

Results 1 to 2 of 2

Thread: two word tablename in sql

  1. #1
    Join Date
    Dec 1969

    Default two word tablename in sql

    I&#039;m still having a problem with this statement:<BR><BR>strSql="Select question" & cstr(fieldNum) & " from " _<BR> & [tableName] & " Where " & cstr(strsql2)<BR><BR>my table name is called Customer Relations<BR>with response.write strsql the statement appears correct in the FROM clause "Customer Relations"<BR>but yet nothing appears with my execute method except for when I just name it one word.<BR>I&#039;ve tried the underscore and checked for the case sensetivity.<BR><BR>in addition, the *tablename* variable is one element in an array.<BR>Any help would be apreciated,<BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default This is just plain bad db design...

    I&#039;m truly trying to help you here and make life easier for you and the guys who may have to maintain your database in the future. Simply don&#039;t use spaces in your table or column names.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts