Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jimny
  • Content: Threads
  • Order by date
  1. jimny

    order by clause acting funny

    I have a cloumn nDays type nVarchar(50)in a table some entries are like "1 & 2" and some are single numbers like "12" or "1". If I execute "SELECT news.nDays FROM News ORDER BY nDays" it orders the results by the leading digit. For example, five rows...
  2. jimny

    Boolean result from SQL Update for asp page

    I know that a sql functin should return a value of -1,0 or 1, but I have no been able to use it to validate whether a process has completed syuccessfully. Example: sql = "UPDATE tblNum t WHERE t.num = '"&num&"'" verify = conn.execute(sql) -- OR preferably-- is there a...
  3. jimny

    Regular Expression for phone number

    I am trying to extract a phone number from a text string, display the first part of string before the phone number, then the second part, then the phone number. I am first splitting the the string: text = cstr(rsAd("adtext")) aryTxt = split(text," ") then am looping to find...
  4. jimny

    Newbie needs help with QueryString

    I inherited a PERl/PHP(and I am not familiar with) site and am getting an error when looking for a querystring value. the original HREF is like: <A class=listLink href=&quot;artist_frame.shtml?artist_id=10&quot; target=cag_content>Artist 10</A> and the code on the recieving page is...
    • jimny
    • Thread
    • Replies: 2
    • Forum: PHP
  5. jimny

    Newbie needs help with QueryString

    I inherited a PERl/PHP(and I am not familiar with) site and am getting an error when looking for a querystring value. the original HREF is like: <A class=listLink href=&quot;artist_frame.shtml?artist_id=10&quot; target=cag_content>Artist 10</A> and the code on the recieving page is: $id =...
    • jimny
    • Thread
    • Replies: 1
    • Forum: Perl
  6. jimny

    If then else not processing...

    I have the following code... IF EXISTS (SELECT Address.AD_ID FROM Address WHERE Addr_ID = '319' AND AD_ID = '1') THEN UPDATE Address SET Street = 'Street1',City = 'City1',ST = 'ST1',ZIP = 'ZIP1',Phone = 'Phone1' WHERE Addr_ID = '319' and Ad_ID = '1'; ELSE INSERT INTO...
  7. jimny

    Carriage Return/Line Feed

    I am interfacing with a program that returns data in a textfile. I am able to enter a query in the format of {tablename.field}^{tablename.field}|. I am trying to automate the process using DTS but I get a prompt that it(DTS) can not find the row delimiter (|), but if I click through and...
  8. jimny

    Using CONVERT for Varchar to Money

    I am doing an insert on an ASP page, and not able to insert a value in to a column with a datatype of 'Money'. I have tried several different ways of doing it, but get the same result with all. Here is the ASP part of geting the variable value: ResCost = request(&quot;Reservation_Cost&quot;)...
  9. jimny

    Page getting hung in Netscape

    I modified a mortgage calculator to amortize based on the starting month. The logic is fine and everything works nice in IE, but the algorythm gets hung in Netscape. Can anyone identify if one of the methods or functions is erroneous. Whole code for the page is included... <HTML> <HEAD>...
  10. jimny

    Invalid argument for visibility property?

    I wrote this snippet for an expandable directory listing and it returns a JAVASCRIPT ERROR: Line 64: Char 8 Error: Coould not get the Visibility property. Wrong argument Here is the code: <HTML> <HEAD> <TITLE>My Drop Down</TITLE> <SCRIPT LANGUAGE=javaScript> <!-- //First DropDown Menu...
  11. jimny

    foreign key restraint error

    i am getting an error on an insert and when I look at the table I can't find (where) this restraint lives or how to get arouond it. Here is the error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with...
  12. jimny

    An uneccessarily lengthy query

    There must be an easier way to get the same rsults from this lengthy query. I am trying to return the average of each column excluding rows that contain the value '0'. this is on ASP page, but the SQl is more my issue. strSQL = &quot;SELECT count(*) as Rows,sum(q1) as sq1,sum(q2) as...
  13. jimny

    XML Validate?

    I have an ASP app that interfaces with an app that returns its results in XML. I have had a randomly recurring problem with the server returning an &quot;Object Required&quot; error message regarding my &quot;TopNode&quot; which is the XMLDoc.FirstChild. I have tried various ways of error...
    • jimny
    • Thread
    • Replies: 0
    • Forum: XML
  14. jimny

    .absolutepage property of Recordset

    In an ASP page I am trying to use rs.absolutepage but continually get ADODB.Recordset error '800a0cb3' Object or provider is not capable of performing requested operation. /classified search/basicCS.asp, line 90 I installed the latest sevice pak for JET(service pack 6.0) on the server...
  15. jimny

    .absolutepage property of Recordset

    In an ASP page I am trying to use rs.absolutepage but continually get ADODB.Recordset error '800a0cb3' Object or provider is not capable of performing requested operation. /classified search/basicCS.asp, line 90 I installed the latest sevice pak for JET(service pack 6.0) on the server...
  16. jimny

    Simple Xpath question for a newbie

    On an ASP page,Is: if(TopNode(node())) then the same as: if(TopNode(node()[1])) then in a check to see if the TopNode exists?
    • jimny
    • Thread
    • Replies: 0
    • Forum: XML
  17. jimny

    Another &quot;text&quot; field problem

    This might be lengthy, but I was reading CoolCoders' Post & Slr22s' post, but could not apply those responses to my problem. I am loading a table weekly from a .txt file generated by an application. It is on an ASP page, but does not necessarily have to stay there. I get through 5 inserts...
  18. jimny

    Cached scripting engines &amp; Memory

    I have general question regarding cached scripting engines & memory usage. We are running IIS5 with windows 2000 server. I have this one app that we launched 3-4 weeks ago, that a specific object genreates a &quot;object required&quot; error message about 5% of the time. When asking someone...
  19. jimny

    loading a recordset from textfile

    I am trying to create a recordset from a textfile. I have imported and seperated the records in the text file: Set fs=Server.CreateObject(&quot;Scripting.FileSystemObject&quot;) Set f=fs.OpenTextFile(Server.MapPath(&quot;penny.txt&quot;), 1) do while f.AtEndOfStream = false ad= f.ReadLine...
  20. jimny

    Importing text file

    I do not have much experience with SQl but... I am running sql server 2000 and am trying to import a text file that looks like: |Lots-Land & Acreage|,|02/26/2003|,|03/12/2003|,||,||,||,|250,000|, |HOPEWELL|,|Beautiful Farm Land, lakes, streams, lots of animals.|,|| I have tried the import...

Part and Inventory Search

Back
Top