| Author |
 Topic Search  Topic Options
|
padoxky 
Groupie
Joined: 17 June 2004
Location: Nigeria
Status: Offline
Points: 78
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 14 July 2005 at 2:11pm |
|
Remeber there's no primary key in tbl2 and no autonumber.
|
|
NgWebDesigns
|
 |
padoxky
Groupie
Joined: 17 June 2004
Location: Nigeria
Status: Offline
Points: 78
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 July 2005 at 4:58am |
Is there anyone going to help me out?
ub3rl337ch3ch,
I expect you to help me out please
I want to displayed the records in tbl2.
|
|
NgWebDesigns
|
|
pmormr
Senior Member
Joined: 06 January 2003
Location: United States
Status: Offline
Points: 1479
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 July 2005 at 3:36pm |
|
there are hundreds... if not thousands of articles on how to use the SQL SELECT command... use the magical google
|
|
|
|
padoxky
Groupie
Joined: 17 June 2004
Location: Nigeria
Status: Offline
Points: 78
|
Post Options
Thanks(0)
Quote Reply
Posted: 18 July 2005 at 5:25am |
hey pmormr,
i suggest u read the last post before replying. Just read the previous post okay.
cox i know what am asking of.
|
|
NgWebDesigns
|
|
pmormr
Senior Member
Joined: 06 January 2003
Location: United States
Status: Offline
Points: 1479
|
Post Options
Thanks(0)
Quote Reply
Posted: 19 July 2005 at 12:42am |
|
Most of us are very knowledgeable about ASP and SQL and very generously provide our time to helping others out. Now if you're not going to show some effort then you might as well as hire a professional (i charge anywhere from 20-60 dollars per hour depending on the project)
Now, the datatype mismatch is due to the fact that you're missing single these thingys (') around UID, and you don't have to use the brackets around all your column names. You may only leave out the hyphens when you're using a number. The UID field is as you said before text, so it must be surrounded by hyphens or you get a datatype mismatch error (i.e. numbers don't work too well with strings) If you look into it more, there are also different symbols for different datatypes... that is stuff like the # symbol for dates.
strSQL = "SELECT col1, col2, col3, uid FROM tbl2 WHERE uid='" & userID & "';"
Edited by pmormr - 19 July 2005 at 12:43am
|
|
|
|
padoxky
Groupie
Joined: 17 June 2004
Location: Nigeria
Status: Offline
Points: 78
|
Post Options
Thanks(0)
Quote Reply
Posted: 19 July 2005 at 10:08am |
Thank you pmormr,
I will apply this method u show me now.
i get to you when is okay.
|
|
NgWebDesigns
|
|
padoxky
Groupie
Joined: 17 June 2004
Location: Nigeria
Status: Offline
Points: 78
|
Post Options
Thanks(0)
Quote Reply
Posted: 19 July 2005 at 3:10pm |
|
I have try the method no error again but, it display a
blank page instead of my web contents and info in my database.
|
|
NgWebDesigns
|
|
pmormr
Senior Member
Joined: 06 January 2003
Location: United States
Status: Offline
Points: 1479
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 July 2005 at 9:23pm |
just opening the database isn't going to cause it to be displayed, you need to go through each record and print it to the screen. See this page: http://www.w3schools.com/ado/ado_recordset.asp
|
|
|
|
