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 Rhinorhino 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: paragvshah
  • Order by date
  1. paragvshah

    Using cursor in recursive stored procedure

    Here is the procedure. CREATE PROCEDURE [dbo].[usp_SubJobwiseBoms] @passSrNo int AS declare @CursorStr3 varchar(750), @getinQty numeric(18,3), @getinRemarks varchar(100), @getinItemcd varchar(13), @getinItemDesc varchar(100) SET @CursorStr3 = 'DECLARE TableCursor3 CURSOR FOR Select...
  2. paragvshah

    Using cursor in recursive stored procedure

    I am calling a stored procedure and i am using a Cursor to fetch some rows from table and inserting it in a Temp Table. after inserting the data I am calling the same procedure inside the cursor and then the Cursor is closed. This gives me an error that cursor is already open. How can I sort...
  3. paragvshah

    SQL Date Problem

    Thnx all where LastDATE = convert(varchar(10),GetDate(),111) This worked out. Parag
  4. paragvshah

    SQL Date Problem

    DickieBird, This is not working out. Its still displays the date as 1/1/2003 etc. Parag
  5. paragvshah

    SQL Date Problem

    Friends, I have one query, I am using a table with a field name lastDate and Datatype is varchar(10). I am storing the date in (yyyy/mm/dd) format in the table. Now I want a query which would compare the dates from lastdate field in the table with the currentdate (getdate()) and retreive the...
  6. paragvshah

    Getting the Binary Data from SQL

    I am getting junk data on the page while displaying the image. Parag
  7. paragvshah

    Getting the Binary Data from SQL

    Hi All, I want to display an image stored in as "Image" Datatype in SQL. I am able to Insert the data in the table but while retreiving, it display the junk data. I am pasting the code. Can any one help me out at what place i am wrong...
  8. paragvshah

    Cast varchar to int problem

    I want to insert a row in a table where the datatype of customernumber is varchar(6) and with every insertion of row the cutomernumber should be incremented by 1 after getting the max id. for that i need to cast the customernumber from varchar to int. so i am using the following syntax to get...
  9. paragvshah

    Get Image Dimensions (Width & Height)

    Friends, In my shopping i want to find out the image Dimensions (width & height) for all the products i retreive on the page. I am storing product id and product name in the database. On displaying the image on the page i want to get image width & height of each product. Is there any...
  10. paragvshah

    View Source Problem in IE 5

    I am not being able to access my page source by right click or by View --> Source option. I have not found any help on this. Please can any one help me out how this problem can be sorted out. Parag
  11. paragvshah

    <b>Formatting in TEXT Format</b>

    Ok I'll have to use dots instead of spaces. Thanks, Parag.
  12. paragvshah

    <b>Formatting in TEXT Format</b>

    Space(10) is also not working. It just shows 1 whitespace between 2 words. I am pasting the code that i have written for your perusal. If you have any suggestions. Here is my code: MyBody = MyBody & "You ordered the following items:"& vbnewline & vbnewline MyBody = MyBody &...
  13. paragvshah

    <b>Formatting in TEXT Format</b>

    I have already tried sending the mail using Multiple vbtab and chr(9). But its not working. It shows only one whitespace between 2 words. so now how can i give multiple whitespaces. Pls help me out. Parag.
  14. paragvshah

    <b>Formatting in TEXT Format</b>

    I want to send mail in Text format using cdonts. I want to format the text to be sent, but i am having problem using vbtab. It doesn't allows multiple spaces between words. How do i format the text for this: TYPE Price Quantity...
  15. paragvshah

    Printing a Recordset

    Friends, I want a give an print option on Website from where a user can print data from a Recordset. we dont want to show the data on the page. Please help me out. Parag.
  16. paragvshah

    .bmp files with Netscape 6.2

    Friends, I am displaying some .bmp images on a page. But the images are not visible in Netscape 6.2 version. In view source i am able to see the code as img src="image.bmp". then why i am not being able to view the image. Please help me out. Parag.
  17. paragvshah

    Netscape 7.0

    Hi friends, I have a problem using Windows media player 7.1 with Netscape 7. I have embedded the following code in a test.htm page. <object id=&quot;objMediaPlayer&quot; width=350 height=275 classid=&quot;CLSID:22D6f312-B0F6-11D0-94AB-0080C74C7E95&quot...
  18. paragvshah

    Find &amp; Replace text thru SQL

    Friends, I want to know what function is there in MS-ACCESS 2000 to Find & Replace a text in a SQL statement written on asp page. Please let me know asap. Parag.
  19. paragvshah

    CFFILE tag error

    Webmigit, This code is working fine in some machines and in some machines its giving this error. What could be the reason to this?.. Parag.
  20. paragvshah

    CFFILE tag error

    Hi friends, I want to accept only 3 formats (.asf, .wmv, .wma)to upload on my site so i am using CFfile tag to validate the file format uploaded by a user. i am using cftry & cfcatch to catch any errors but on some machines the code mentioned below is working and on some machine is giving...

Part and Inventory Search

Back
Top