how to make column of table 1 = to column of table

gilgalbiblewheel · October 11th, 2004, 08:45 PM

I want MS Access 2000 database column of table 1 = column of table 2.

This is what I was doing:

Code:

<%
'Option Explicit
'Response.End 
Response.Buffer=false

Dim letter

'SQL = "SELECT bible.book_spoke, biblewheel_url.letter FROM bible, biblewheel_url WHERE bible.book_spoke=biblewheel_url.book_spoke" 

    SQL = "SELECT * FROM biblewheel_url WHERE "
    strConn = GetConnectionString()

SQL = SQL & "letter(biblewheel_url.book_spoke) = rs(bible.book_spoke)"

    Set letter = Server.CreateObject("ADODB.Recordset")
    letter.CursorLocation = adUseClient

    letter.Open SQL, strConn, adOpenForwardOnly, adLockReadOnly
%>
<%=letter("url")%>
<%
    letter.Close
    set letter = Nothing
%>

and to pull url address of table 2 to which record it is =to

happygv · October 11th, 2004, 11:37 PM

Quote:

quote:SQL = SQL & "letter(biblewheel_url.book_spoke) = rs(bible.book_spoke)"

Can you post on what comes in rs(bible.book_spoke)? Though you can modify that as

Code:

SQL = SQL & "letter(biblewheel_url.book_spoke) = " & rs(bible.book_spoke)

Not sure what datatype it is, so use single quotes around if required.

Cheers!

_________________________
- Vijay G
Strive for Perfection

gilgalbiblewheel · October 11th, 2004, 11:49 PM

Yes. This is what I get:

Code:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

[Microsoft][ODBC Microsoft Access Driver] Undefined function 'letter' in expression. /wheelofgod/letters.asp, line 18

letters is an "include" asp file. The purpose of this is to match the column of table 1 with the column of table 2 because table 2 has url links for each record. Thus by clicking on the link I should get different url depending what the number is.

Example I have "book_spoke" from table 1 which has a value of '15'. It should match with the "book_spoke" from table 2 which has the same value. (which one has to be primary key?). So table 2 has a url for each "book_spoke" value.

RS is supposed to be the recordset for the first sql. Letter is supposed to be the recordset for the second. I don't know if it makes sense. The second sql is for the second table.

gilgalbiblewheel · October 11th, 2004, 11:53 PM

ok. I tried your line and it says:

Code:

Microsoft VBScript runtime error '800a01a8' 

Object required: '' 

/wheelofgod/letters.asp, line 14

happygv · October 11th, 2004, 11:57 PM

what is on line 14? did you declare RS?

_________________________
- Vijay G
Strive for Perfection