Very dependent upon what DB using and thereby what type of SQL, PLSQL? TSQL?
Weird Access SQL?
The best thing to do would be print out the SQL via out.print or some
incantation of println and copy and paste that statement into a SQL query
window, then tweak it until it gets you the result you need. The error is
not so much in the "code" syntactically but more in what you're asking for.
Matt
Matthew L. Wright
Java Internet Programmer
Jupiter One
Web World Studios West Coast
www.jupiterone.com
(818) 763-2927
----- Original Message -----
From: "sahaya ranialex" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 28, 2001 7:16 AM
Subject: Re: allaire JDBC driver.
> In my developement environment i have Jrun 3.0 development edtion & BEA
jdbc
> driver trial.Now i am shifting to pre production server(JRun 3.0
Enterprise
> with jdbc type 4 driver which comes with that),there only
> i am getting this problem
>
>
>
> allaire driver try to popuplate the table
> 'Datetime' column with Date &time, even though i am passing only sqlDate
> object using insert stt.It was not happening with bea driver.
>
> For select stt also,i am passing sqlDate object in the where clause,it
> searches for date&time in the table returns null resultset.
>
> Is this the way it suppose to work? or it is a bug?
>
> sahaya.
>
>
> >From: "sahaya ranialex" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: JRun-Talk <[EMAIL PROTECTED]>
> >Subject: Re: allaire JDBC driver.
> >Date: Tue, 27 Mar 2001 15:34:05 -0000
> >
> >String query1="SELECT stoplight,prod_element_id "+
> > "FROM prod_list "+
> > "WHERE bemsid=? AND submitted_date=? "+
> > "ORDER BY prod_element_id ";
> >i inserted space after question mark
> >it does not throw any any excepion but no resultset
> >
> >i thiink expects date with time as it populates.
> >
> >Still i need some suggestion for this problem
> >
> >sahaya.
> >
> > >From: "sahaya ranialex" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: JRun-Talk <[EMAIL PROTECTED]>
> > >Subject: allaire JDBC driver.
> > >Date: Tue, 27 Mar 2001 15:05:30 -0000
> > >
> > >Hi there,
> > >
> > >I am using JRUN enterprise in solaris,database as sqlserver 7.o runs on
> > >win-NT 4.0.
> > >Here is my snippet
> > >bemsid=rs1.getInt(1);
> > >.....
> > >String query1="SELECT stoplight,prod_element_id "+
> > > "FROM prod_list "+
> > > "WHERE bemsid=? AND submitted_date=?"+
> > > "ORDER BY prod_element_id";
> > >java.sql.Date sqldate0 =new java.sql.Date(date.getDate0().getTime());
> > >pst=con.prepareStatement(query1);
> > >
> > >try{
> > >
> > > pst.setInt(1,bemsid);
> > > pst.setDate(2,sqldate0);
> > > rs=pst.executeQuery();
> > > for(int j=0 ;j<13&&rs.next();j++){
> > > date0[j]=rs.getString(1);
> > > }
> > > rs.close();
> > >}catch(SQLException e){out.println("0"+e);}
> > >
> > >i am getting the below error.
> > >0java.sql.SQLException: [Allaire JRun][SQLServer JDBC
> > >Driver][SQLServer]Must
> > >declare the variable '@P2ORDER'.
> > >
> > >The same query runs fine in SQL query analyser.& also using BEA type 4
> >jdbc
> > >driver.
> > >In my developement environment i have Jrun development edtion & BEA
jdbc
> > >driver trial.Now iam shifting to pre production server,there only i am
> > >getting this problem
> > >
> > >Does any one have any clue to this?
> > >
> > >one more pbm i across is, allaire driver try to popuplate the table
> > >'Datetime' column with Date &time,It was not happening with bea driver
> > >it just populate with date only.
> > >
> > >
> > >sahaya
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
