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 Chriss Miller 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: *

  1. cybercop23

    Printing from ASP

    Mighty, I have a similar issue. We use a pocketpc handheld that uses IE to gather some data. I need to print to a remote print server located by the mobile user from the ASP page. I was thinking of doing something similar where I set up the remote printers on the server so I can print to them...
  2. cybercop23

    getting count of find command

    Thanks All. I echoed the output to a file and read the file back in using the "for" command and tokens and it worked. Thanks.
  3. cybercop23

    getting count of find command

    Hi all. I'm trying asign the result of a find command to a variable that I can check. If the result is what I expect I can continue processing, else wait some more. This is what I mean: :checkdone set checkdone=dir done*.txt | find /c "done" if checkdone == 5 goto done sleep 60 goto checkdone...
  4. cybercop23

    Multiple batches

    Thanks a lot. Works like a charm.
  5. cybercop23

    Multiple batches

    Hi. I'm trying to create a batch file that will be kicked off by the command scheduler, that will in turn kick off three other batches at the same time. Each batch runs about 30 minutes, so I want to kick them all off at the same time, as opposed to sequentially. Here's what I mean: Commnad...
  6. cybercop23

    converting from char(8) to smallmoney

    Thanks much George. Had to cast the Amount from char(8) to numeric, and it worked.
  7. cybercop23

    converting from char(8) to smallmoney

    George, That what was in my example. When I divide, it loosed the cents. So 123456 should be 1,234.56, however cast and convert will result in 1234.0000. It looses the 56 cents.
  8. cybercop23

    converting from char(8) to smallmoney

    Hi all. I have some data that I'm importing from an ODBC. The source data is money represented as 123456 (1234.56). I import it as char(8) but need to display it to the user as 1,234.56. I tried convert, but it truncates the cents: CONVERT(smallmoney, Amount/100) 123456 -> 1234.0000...
  9. cybercop23

    Separate DateTime filed into Date and Time

    The field type is datetime. I want to sepate them because of two things: 1) need to create an index on date and don't think I would like the time included in that index and, 2) The user will access this data via an ASP page that will ask for the start date and end date for what they are looking...
  10. cybercop23

    how do i publish a sql server db on iis?

    Best place to start when wanting to publish MS SQL data is www.asp101.com. They have lots of examples. Just cut and paste the code samples and change the connection string. Don't forget to give the user you are using in the connection string access to the database and the table, view or stored...
  11. cybercop23

    Separate DateTime filed into Date and Time

    Hi everyone. I'm loading 100s of thousands of records weekly that have a filed as DATETIME (12/26/2005 11:26:00). I would like to separate this one filed into two. A date field and a time field. I can do that using the cast function. My problem is that I also need to create an index using this...
  12. cybercop23

    Summary problem

    That did it. Thanks.
  13. cybercop23

    Summary problem

    Mercwrought, that worked, except that it gives me the date as mm/dd/yy 00:00:00:0000. If I add the cast to remove the zeros, it again complains that I can't have a cast in my group by. Pattycake245, MS SQL is complaining about the cast or convert in the group by. Since I have numerous records...
  14. cybercop23

    Summary problem

    Hi all. I need to sumarize sales by day for the past month. The issue is that my date field is smalldatetime since I get updated sales every 15 minutes. Here's my select statement: select Str,CONVERT(varchar(10), [TimeStamp], 101) as SDate,sum(NetSalesAmount) as Sales from SaleUpdates where...
  15. cybercop23

    Getting one line at a time from a text file

    It's that easy. Thanks much for the help.
  16. cybercop23

    Getting one line at a time from a text file

    Hi everyone. I have a text file of item numbers. I need to pull one line at a time and pass that to my shell script to process it. How can I pull first line, then 2nd, then third, until EOF? I need to only get one line at a time and then move to the following line. Sample file: 004124012725...
  17. cybercop23

    query results parsed in variables

    got it. dbaccess itemmaster <<stp | sed -n '3p' | read item_description item_size output to pipe cat without headings select upmdesc, upmsize from upm where upmdesc = "$upc"; stp Thanks for the help.
  18. cybercop23

    query results parsed in variables

    Almost there. Now I get the column headings put into the variables. query done upmdesc upmsize
  19. cybercop23

    query results parsed in variables

    blank like blank like upmdesc upmsize testitem 1 lb blank like 1 row(s) retrieved. blank like blank like can it be because of the blank lines? how do i get...
  20. cybercop23

    query results parsed in variables

    Tried that and the variables are null. I've added the following print statements: echo query done echo $item_description echo $item_size And the result is: 1 row(s) retrieved. query done Note that there's nothing...

Part and Inventory Search

Back
Top