Re: type mismatch on getting time defference Programming Software Development by rishif2 rs.Open "Select Count(DateIn) as Total from Time_In where Employees_IdNo = '" & sTrID & "'", cn, adOpenKeyset, adLockPessimistic If Not rs.EOF Then lblTotal_Days.Caption = rs!Total Now close rs and once again open it , so type the following rs.Close set rs = Nothing… Re: getting distinct req_no is a list box Programming Software Development by ryan311 rs.Open "SELECT Distinct * from mr ", con, adOpenDynamic, adLockOptimistic Re: getting distinct req_no is a list box Programming Software Development by ryan311 rs.Open "SELECT distinct(*) from mr ", con, adOpenDynamic, adLockOptimistic Re: search using dtpicker Programming Software Development by pubudusr rs.open "select * from tblrecord where Birthday = '" & DTPicker1.value & "'", cn, adOpenDynamic, adLockOptimistic Re: whats wrong here??? Programming Software Development by vb5prgrmr rs.addnew rs.fields("somefield") = somevalue rs.update Good Luck Re: JDBC Programming Software Development by JamesCherrill rs is an instance of ResultSet, so you can use the Java API documentation to learn all about its methods, eg http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getString%28int%29 Re: ADODB.Recordset (0x800A0E78):Operation is not allowed when the object is closed. Programming Web Development by campkev rs.NextRecordset look here [URL="http://www.w3schools.com/ado/met_rs_nextrecordset.asp"]http://www.w3schools.com/ado/met_rs_nextrecordset.asp[/URL] Re: code for update Programming Software Development by asrith001 rs!dealercode = Text1.Text rs!dealername = Text2.Text rs!dealeraddress = Text3.Text rs!pincode = Text4.Text rs!city = Text5.Text rs!State = Text6.Text rs!email = Text7.Text rs!phone = Text8.Text rs.update this is my update code Re: how to get the difference between the data of the two files Programming Software Development by yello rs.open "SELECT C2 FROM Table_Name" C2R1 = rs("C2") rs.MoveNext C2R2 = rs("C2") compare C2R1 and C2R2 Hope this helps. Re: vb6 Clinic system how to display total quantity on textbox Programming Software Development by Ferdielux rs="Select StockQuantity from inventory",connection,3,3 txtbox1.text="" while not rs.eof txtbox1.text=val(txtbox1.text)+ rs!StockQuantity wend Hope it help tanx Re: Sensor Programming Programming Computer Science by wildgoose RS-422 or RS-485 would be an appropriate serial connection. Handles distance. Since it sounds like you're putting a processor (may I recommend a PIC) directly attached to the sensor(s) you may consider putting an LED on an output driver as well. You can self test by toggling the LED on and off and monitoring the input sensor. Re: Stored Procedures in MySQL does not retrieve more than one row Programming Web Development by Rizwan_2 $rs = mysqli_query($conn,"Call GetProducts") or die(mysqli_error($conn)." Query=".$sql); $result = array(); while($row = mysqli_fetch_array($rs)){ array_push($result, $row); } echo json_encode($result); Re: selecting items from listbox Programming Software Development by kehar rs. open " Select * from <table name> where name ='" & list1.text & "'",cn, adopenstatic, adlockoptimistic and suppose the list box items are -1. Mohan 2. Sohan 3. Rohan When I click on Sohan or Rohan i.e. on item 2 or item 3 the programme does not respond despite having data in the table. so how to … Re: SQL querry Combo Box Question Programming Software Development by needhelp// rs.Open "insert into traveldet values('" & Text1.Text & "' ,'" & saccdate.Text & "','" & sretdate.Text & "','" & stype.Text & "','" & smodel.Text & "','" & Combo1.Text & "','" & Combo2.Text & "',null,'" & … Re: insert combo box value into database table in oracle Programming Software Development by needhelp// rs.Open "insert into traveldet values('" & Text1.Text & "' ,'" & saccdate.Text & "','" & sretdate.Text & "','" & stype.Text & "','" & smodel.Text & "','" & Combo1.Text & "','" & Combo2.Text & "',null,'" & … Re: Print record from two set of dates? Programming Software Development by abelingaw rs.Open "Select * from TABLENAME where COLUMNFORTIME Between #" & Combo2.Text & "# AND #" & Combo1.Text & "#;", con, adOpenKeyset, adLockPessimistic Perhaps.. JAX-RS and J2EE Programming Software Development by c.pentasuglia I have a pretty good understanding of what JAX-RS or any web-service is, but i have to question why use it? I have learned to use J2EE implementing a web application (JSP, JavaScript, CSS) that uses Service Classes to interface with EJB's, which then those EJB's interface with an EIS (In my case resource adapter). So i never had the need for … Re: JAX-WS vs JAX-RS Programming Software Development by ~s.o.s~ I would personally start with [this](http://docs.oracle.com/javaee/6/tutorial/doc/gjbji.html) for a very high level view or maybe [this](http://www2008.org/papers/pdf/p805-pautassoA.pdf) if you are into whitepaper and stuff. [A more detailed tutorial of JAX-WS](http://docs.oracle.com/javaee/6/tutorial/doc/bnayl.html) [A more detailed tutorial of … JAX-WS vs JAX-RS Programming Software Development by pmark019 What are the differences and similarities of JAX-WS and JAX-RS? Re: JAX-WS vs JAX-RS Programming Software Development by JamesCherrill I assume that you did take a quick moment to Google *JAX-WS vs JAX-RS* before asking for help... Having read the first few answers from that search, what uncertainities are you trying to get resolved here? Re: JAX-WS vs JAX-RS Programming Software Development by Ne0nx3r0 Could this thread be removed? It's one of the top Google results for "jax-rs vs jax-ws" and it offers absolutely no help, not even reference links. rs.next() returns true, but if (rs.next()) block not executed Programming Software Development by jwdvorak In the following method: [CODE] public boolean isMemberAlive(String userSsn) throws SQLException { boolean isMemberAlive = false; Connection c = null; Statement s = null; ResultSet rs = null; String strSQL = "SELECT Count(*) AS RecordCount " + "FROM crs.memmst " + "… Re: rs.next() returns true, but if (rs.next()) block not executed Programming Software Development by javaAddict Try to put more debug messages: [CODE] System.out.println("Checking rs"); if (rs.next()) { System.out.println("rs.next: TRUE"); int rc = rs.getInt("RecordCount"); System.out.println("rc= "+rc); if ( rc> 0) { … Re: rs.next() returns true, but if (rs.next()) block not executed Programming Software Development by roswell67 I am not sure why this is happening. But what you could try is. [CODE] if (rs.next()) { if (rs.getInt("RecordCount") > 0) { isMemberAlive = true; } }[/CODE] Change it to [CODE] boolean statement = rs.next(); if (statement) {… Re: rs.next() returns true, but if (rs.next()) block not executed Programming Software Development by jwdvorak To reiterate... I put a breakpoint at line #21, examined the variables... rs.next() returned true - but when I continued (step over), the code skipped past the statements in the if block directly to the finally block. Seems impossible (!)... been fighting this for a day or two. Using Eclipse JEE Ganymede, deployed on JBoss 4.2.2, Oracle back end.… Re: rs.next() returns true, but if (rs.next()) block not executed Programming Software Development by javaAddict Post the code with "System.out.println" and tell us what it is printed and what is not. Does the [I]rs.next[/I] returns true? What is the value of [I]rc[/I] ? $rs=mysql_query($sql) or die(&quot;error in common.inc.php at line 257&quot;); Programming Web Development by oracle4me Hello please help Total php beginner please help i am going crazy my home-page opens finishes loading but with error's on page and my hitcounter does not display on my site but it's still logging my site I looked through my site files and found this error below. Is this the problem i hope please help me everything is so complex for me to … rs.filter Programming Software Development by Carlo Miguel whats wrong with this.. its not working! Set rs = New ADODB.Recordset rs.Open "select * from Personal inner join Company on Personal.CompanyID = Company.ID", conn, adOpenKeyset, adLockOptimistic rs.Filter = "FirstName LIKE '*" & searchtxt.Text & "*'" Re: RS within ROWS Programming Software Development by selvaganapathy Hi U can access the column by index. Example To access the 0th column u can use [ICODE] RS.Fields(0) [/ICODE] Similarly u can iterate all the columns Ex [CODE] Dim i as integer Dim s as String For i = 0 To RS.Fields.Count -1 s = s & RS.Fields (i).Name Next MsgBox (s) [/CODE] This example shows the all column names one by one I hope this… RS within ROWS Programming Software Development by eparse In my database, the format for 8 columns are as shown: [code] +------+------+------+------+------+------+------+------+ | MPT | MPB | MP1T | MP1B | MP2T | MP2B | MP3T | MP3B | +------+------+------+------+------+------+------+------+ | 4 | 7 | 1 | 1 | 3 | 3 | 0 | 3 | | | | | | | |…