Search results

  1. R

    A Structured Query Language (SQL) challenge

    All, I'm working on a bespoke logging feature for a web portal which records user events in a single table (tblUserLog as illustrated below). id session_id auth_user app_name event remote_addr http_user_agent timestamp 233 1063924932 jim App 1 Some event 10.203.115.30 Mozilla/4.0 (compatible...
  2. R

    The field is too small to accept the amount of data you attempted to add...?

    All, I have inheirited a database which I am attempting to query via an SQL statement: "SELECT * FROM MYTABLE ORDER BY SheetNumber;" This query works fine under Access but when executed thru ADO 2.5 / Microsoft.Jet.OLEDB.4.0 from VB6 it reports the following error ("2147217833"): "The field...
  3. R

    Order by numbered list "1.2.3"

    I have a requirement to sort data of the following format by ref: ref heading ------------------ 1 Section 1.1 Test 1.2 Blah 1.3 Another 1.4 Things 1.4.1 Stuff 1.4.2 Other ... 10.1.1 Something 10.10.1 Else 10.2 Blah blah 2 Some other section 2.1...
Back
Top Bottom