ASP Problem

July 26th, 2016

Sime problem, in my asp script i need to select some values from a table
But because the table has a space in its name the asp keeps returning errors because its only reading the “Mobile” part of the name. How do you show a space in a table name in ASP?
I already tried “Mobile phone” but it doesnt work.
Thanks in advance

strSQL = "SELECT ID,employee_name, phone_number FROM Mobile phone;"

Answer #1
Try putting this value instead of a space: %20.
If not try using a variable and use the html line   to put a space in the name.
It might work. Good luck mate^^
Answer #2
lol yeah tried both those already, still no luck might just end up having to rename the table in the database, but ill loose marks for doing that.
Answer #3
why dont you write error here?
why dont use tblMobilePhone name instead of Mobile phone?

 

| Sitemap |