Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL?

Status
Not open for further replies.

Smitty020

MIS
Jun 1, 2001
152
US
I'm another newbie at ASP. I'm using ASPXP! When I made may first webtable, I followed along with one of the samples! I have a MSAccess2K database that I want to get info from. When I got top the end of the table, there was a part that said: (in the example)

.DataSource.SQLQuery = "SELECT * FROM Employees"

the table I want to use is called "Personnel"
and I want all of the attributes.

I thought mine should look like this:

.DataSource.SQLQuery = "SELECT * FROM Personnel"

Is this right? I'm getting and error about the SQLQuery Part. What should I be using? Any help would greatly appreciated!

Thanks in advance!
Smitty (The epitome of ASP Newbies!)



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top