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
