Recent content by Sqlsa

Hi ruben, Thanks. I will go through some of these documents and try to figure out what to do. I really appreciate your help. Thanks, Sreenivas

Hi rubin, Thanks for all ur help. I am using adobe 4.0. I don't find the options you have shown. But I did not want to do this way. I wanted to use ADOBE object model and program to develop thumbnails. That keeps me safe from the changes users make to their PC settings. Where can I...

Hi rubin, They use Word or Word Perfect program to create adobe pdf documents. What happens is, they receive picture files in word or word perfect documents. Both Word and Word Perfect have ability to generate pdf documents from word or word perfect documents. I don't know what...

Hi, I need to create thumbnail for each and every page of adobe pdf document. Suppose, there are 5 pages in a pdf document. So I need to access the pdf file and create thumbnail images for all the five pages. I have to do this from VB6 application. Each thumbnail image will be stored as a...

Hi, I am not creating pdf document from application. This file is created by the users from a word or word perfect document. Sreeni

Hi, I need to create thumbnail for each and every page of adobe pdf document. Suppose, there are 5 pages in a pdf document. So I need to access the pdf file and create thumbnail images for all the five pages. I have to do this from VB6 application. Each thumbnail image will be stored as a...

Hi, I think you can try using a subquery. Select t1.f1, t1.f2, t2.f1, t2.f3, t3.f3, t3.f4 from t1 inner join t2 on t1.f1=t2.f1 inner join t3 on t2.f3=t3.f3 Where t1.f2 = (select max(A1.f2) from t1 A1 where A1.f1=t1.f1) Since you said all three tables are related, i assumed...

Hi Mimi, If you can't debug stored procedure's code from ColdFusion, then use PRINT statement in the Stored Procedure and check.. --add the following line to check for value of @reason PRINT @reason Add some other PRINT statements to check whether the control is going inside IF and...

Hi McDonald, This may not be the correct way of doing it. But you can try it. This is for extracting the default SQL directory for SQL Server...not Windows default Directory.. If we believe that wherever the data and log files are stored for MASTER database in SQL Server as...

Hi, Try this... Declare @intNumberOfRecords int --cursor code Select @intNumberOfRecords=@@ROWCOUNT Print rtrim(convert(char(10),@intNumberOfRecords)) + ' Records Processed.' Hope it helps. Sreenivas avnsr@hotmail.com -----------------

Hi, Try this... Declare @intNumberOfRecords int --cursor code Select @intNumberOfRecords=@@ROWCOUNT Print rtrim(convert(char(10),@intNumberOfRecords)) + 'Records Processed' Hope it helps. Sreenivas avnsr@hotmail.com -----------------

Hi Gabby, (1) Use REPLACE function to take care of '-' in SERIALNUMBER. ----------------------------------------- --To take care of '-' in SerialNumber Update CallLog set SerialNumber= REPLACE(SerialNumber,'-','') -----------------------------------------...

Hi Louis, The update statement to take care of records with Fulldat as Null should read as UPDATE MAIN SET MAIN.ABBREVIATION = 'NoTextData' WHERE Fulldat is null (NOT is ommitted from the above WHERE clause) Sorry for the correction. The WHERE clause should not have "not". This is...

Hi, Use SUSBSTRING instead of LEFT UPDATE MAIN SET MAIN.ABBREVIATION = rtrim(SUBSTRING(FULLDat,1,125)) But I noticed one thing. If Fulldat has NULL value in it, then Main.Abbreviation also becomes NULL. I believe you want to use this abbreviation for GROUP BY. (I know this because...

Hi, Replace SYSMESSAGE with MASTER.DBO.SYSMESSAGES Because @@ERROR is cleared and reset on each statement executed, check it immediately following the statement being validated or save it to a local variable that can be checked later. (1) Select statement or INSERT statement or UPDATE...