> JDK1.3 + JDBC-ODBC bridge + Access 2000? Yep. > Would you like to try Access 97 or MSSQL server? I suppose I could. I ended up upsizing to SQL Server and it's working fine (and I switched from the JDBC-ODBC bridge), but I'll give Access 97 a try too. Is this a known issue? (I mean w/ Access 2k?) p.s. The QueryTable object seems nice, but is there any way to get a specific column in a specific row? -Ray Camden > -----Original Message----- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 22, 2001 11:35 AM > To: JRun-Talk > Subject: Error when using jrun:sql > > > I've set up a datasource in the JRUN Admin using the JDBC ODBC bridge. I > know this isn't good for 'real' code, but I'm only testing and I wanted a > quick way to connect to an Access db. Anyway, I set it up in the > JRUN Admin > and the test ran fine. However, whenever I do: > > <jrun:sql datasrc="DCForums" id="GetPoll"> > select ID from tblPolls > </jrun:sql> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
