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
