A newbie attempting to connect to .mdb..help. Please? 2

[danielh68]

Hi

I'm trying to learn how to connect to an Access database. I have created a database in Access, uploaded to the database folder, logged into the site control panal, clicked database tools and created a new ODBC connection.

As a side note, I have been following this tutorial at

http://www.haneng.com/Lessons_17.asp

It's fine, until he gets to the control panel under ODBS Data Source Administrator.

My Question is this:

1. Since he's connecting to PWS do I need to do this? Or, does it generate when I creating a database through my ISP's Database control panel.

Or, can someone point me to a more approprate tutorial?

Thanks,
dan

 

[onpnt]

I'm confused
Response.Write(album & " = " & oRS("FolderName&quot.Value)
FolderName is a field in the database correct.
From the way I'm reading it it should return anything that is in the record.
I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.
admin@onpntwebdesigns.com

 

[snowyej]

Yes, hmm... Maybe it's because I have two tables that I'm pulling data from? What's the correct syntax for calling data from a certain field?

oRS("tblAlbum.FolderName&quot.Value ??

I just want it to return the data in that one field.

Thanks much!

Elizabeth

 

[snowyej]

Nevermind, I just figured it out on my own. It was my SQL statement. I didn't need the UNION in there...just needed it like:

SELECT * FROM tblAlbum, tblPhoto WHERE FolderName = '" & album & "'

Now I see the data I want.

Thanks again for all your help!

Elizabeth

 

[onpnt]

This is how I'm reading this from everything

take out the .value
Response.Write(album & " = " & oRS("FolderName&quot)
this says write whatever is in the value of the variable album and write the recordset FolderName which is everything in the record set. all values!

why do you union tblPhoto when you don't use it?
what you are getting for a result is correct rom how I read it, but I don't see the DB so I could be wrong.

yes the way you stated it the second time makes more sense to me.
oRS("tblAlbum.FolderName&quot
this asks for jsut the FolderName in the tblAlbum




I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.
admin@onpntwebdesigns.com

 

[onpnt]

glad I could help both of you out.
thanks for the star
I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.
admin@onpntwebdesigns.com

 

[danielh68]

Your welcome, onpnt.

--Dan