Search results for query: *

Hi, I'm trying to add a new Image type to the Picture Library. I like to add a .dng file to it and also to generate a thumbnail view voor this image. How is this done for the .JPEG files and is it possible to do tis with other images which are not in the default list. .DNG = adobe digital...

Hi, I try to get only one row from a table, when I run “select PhysicalFile, Size_KB from SQLDBSIZE” I get all the physical file locations: C:\Program Files\Microsoft SQL Server\MSSQL. \MSSQL\DATA\WSS_Content_Partners.mdf C:\Program Files\Microsoft SQL...

Hi, I'm trying to extract from the following string only the name: Irma Schmidt String from the DB: EX:"Irma Schmidt"</o=myexchange/ou=first administrative group/cn=recipients/cn=irma> And when I'running the query I got 1000 mailaddresses from the DB and I like only the first 10. Thanks...

Hi, I try to update a table with the following query, the ShPath string is coming from a external source UPDATE SHARES SET group='0' WHERE servername='SRV01' and ShPath = 'C:\USERS_100\' But the ShPath has the entry C:\USERS_100 how can I remove the \ behind the C:\USERS_100\ Thanks, Navmen

Hi I try to collect all tranactions of today with the following query and that works fine, but now I try to get information from the last 7 days and I don't get it to work. select * from STH_POL_REPORT where date = CONVERT(varchar(30),getdate(),101) Date field format is: 02/28/2008...

Hi, I'm trying to remove some characters from my text string below, with Right I can remove the word CONTAINS(', How can I remove with the same query the characters ') on the end of the string. CONTAINS('"court" OR "judicial" OR "case number"') select Right(POL_QUERY...

Hi All, I'm trying to put this String: [COLOR=red]CONTAINS('""*aco"" NEAR ""*EVIN""')[/color red] into a table. Using: Insert Into POL_POLICY(POL_QUERY) Values ('CONTAINS ('""*aco"" NEAR ""KEVIN""') ') Doesn't work, what must I do to get it right....!! Maybe it is easy but I don't see it...

Hi, How can I remove a part of a string, what I try to do is removing the ($dir1) C:\eval form the string $filename example c:\eval\new document.doc. And when there is a sub folder I like to display \Folder\New document.txt. without the c:\eval The following script gives me already a lot of...

Hi, When I run this Perl script from an other directory then the C:\EVAL it will shortcut all the files in the C:\EVAL directory (not checking the last access time). Running the Perl Script in the C:\EVAL directory everything works fine. I got the error “Use of uninitialized value in...

Hi, I’m trying to get information from the SQL server and with this information I like to create directories on a Windows Server share. The following script works fine except the creation of the directories on the Windows Server share is not working...

Hi, I’m trying to extract some information from a stored message in the SQL database, the message looks like: Info –I : Message Text [windows event xxx] I like to extract the information between the “:” and “[“ the query I created is as follows: Select substring(message,9,500) as 'Message'...

Hi, Can some help me with the following problem I’m trying to create a query which gives me the Average for a day? I created the next query, but it’s not reporting one Average value. ---------------------------- SELECT drive, round((cast((avg(sessions)) AS DECIMAL(10,0))),2) as 'conn', rate...

Hi, I try to create a perl script which execute a command and to receive the information (output) from a the command into variables of perl and to store them in a database. Works fine! Except when there is a space in the output, like name:”VSS Data” this generate a problem in storing the...

Hi, Can someone help me with the following: We like to calculate the time (duration) between Start time and End time of a process, we created two tables with the names “sscreate1” DataType=datetime as Start Time and “sscomp1” DataType=datetime as End Time. I have no idea how the SQL queries...

Hi, I'm using the following statement for reporting information on daily basis: convert(char(10),GETDATE(),101) = convert(char(10),sscreate1,101) But, how can I report information sinds yesterday or 12 days ago with the GETDATE? Thanks, J