943,200 Members | Top Members by Rank

Web Development > ASP > ASP Join Problem?
Ad:
  • ASP Discussion Thread
  • Marked Solved
  • Views: 89
  • ASP RSS
Permalink
Jul 18th, 2010
0

ASP Join Problem?

Expand Post »
I'm hoping someone can help me here.

I have 2 tables in a access database. I'm trying to join certain data points from both, simple. I've done a few joins already for this site. But the problem I'm having is this one seems to be destined to annoy me.

ASP Syntax (Toggle Plain Text)
  1. sql = "select synBLR.*, wFittings.* FROM synBLR INNER JOIN wFittings ON synBLR.master" & u_legs & "link = wFittings.ID WHERE synBLR.blrID = " & u_blrID &""
  2.  
  3. rs.Open sql, cn

The main table is synBLR, in this table there are 6 data columns I need, including master[2,3,4]link columns. User makes their selection in the form, and the data passes as normal to the asp code, no problems there. The problem is the MasterLink column is filled with IDs that refer to wFittings data. Again there are several data points I want out of wFittings. In short, 4 data points are entered by the user, the u_blrID, feet, inches, and u_legs. I checked with response write to make sure u_legs was being entered properly, so I'm fairly certain its good. But in the end I still keep getting the same error:

ASP Syntax (Toggle Plain Text)
  1. Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
  2.  
  3. [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
  4.  
  5. /blp/roundslingc/mroundslingc.asp, line 32

Line 32 is the line that opens SQL statement.

Can someone please help me here?
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
hatrickwah is offline Offline
11 posts
since Jul 2010
Permalink
Jul 19th, 2010
0
Re: ASP Join Problem?
Keeping it simple may help:
ASP Syntax (Toggle Plain Text)
  1. SQL = "SELECT * FROM Table1 LEFT JOIN Table2 ON Table1.criteria = Table2.criteria Where Table1.Something = " & strSometing
Reputation Points: 5
Solved Threads: 14
Junior Poster
ArtistScope is offline Offline
146 posts
since Jun 2010
Permalink
Jul 19th, 2010
0
Re: ASP Join Problem?
Turned out it was an issue with Access database. I converted everything to MS SQL and the script work from then on. It seems Access has issues with Joins, I've had to trick the system into doing what I need, now the system seems to work just fine.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
hatrickwah is offline Offline
11 posts
since Jul 2010

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP Forum Timeline: Deleting records by ConnectingString
Next Thread in ASP Forum Timeline: ASP Search MS SQL Float


Tags
access, asp, sql



About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC