Search results for query: *

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...

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...

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

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

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...

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

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...

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...

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...

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

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

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 &...

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.

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...

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.

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.

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...

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.

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.

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...