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 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 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...
Hi ,
Try this...use UNION
Select NAME from TABLE where NAME like 'Volksvagen'
UNION
Select NAME from TABLE where NAME not in ('Volksvagen')
ORDER BY NAME
Hope it helps.
Sreenivas
avnsr@hotmail.com
-----------------
Hi,
Change the datatypes of columns ID_Job, ID_BDL, mybundle to VARCHAR (I expect them to be CHAR datatype now)if the values for ID_JoB and ID_BDL have varied lengths.
Otherwise trimming the data in these columns always help.
LTRIM may not be necessary, but RTRIM will be required.
Hope it...
Hi,
Try this..
Update CallLog
set SerialNumber=
left(CLSerialNumber,charindex('-',CLSerialNumber))
Refer BOL for Functions List..You will find a lot about String functions, Date functions, all kinds of functions..
Better look at BOL.
Hope it helps.
Sreenivas
avnsr@hotmail.com...
Hi,
(1)DatePart(mm,GetDate()) for month
(2)DatePart(yyyy,GetDate()) for year in four digits
(3)DatePArt(yy,GetDate()) for year with last two digits
Use any datetime type of coulmn in place of GetDate() if that's what you want to do.
Hope this helps.
Sreenivas...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.