Search results for query: *

Thanks DBomrrsm That worked. Once i created the .cvs I had to rename it as .txt file to simplify the data source process, but that was it. cheers kitty

Hi SQLSister I tried that. If i have the cells empty ie: delete the words emptyCell it just imports everything as a <NULL>. If i put a random default date in eg: 01/01/1900 instead of emptyCell, then it's fine and it will import the dates correctly. That solves the problem there but it's not...

Hi I have a table in excel, which either has a date or says emptyCell. HLDR ----- 22/09/1988 emptyCell emptyCell 22/06/1993 1/04/1991 29/03/1990 I am trying to import the data (using the import wizard)into sql server, but even if i set the datatype to varchar or nvarchar for the destination...

Hi Paul Thanks for the code you posted, it does need modifying where you indicated, but i'm using it as a starting point. If you get anymore flashes of inspiration please let me know. cheers kitty

Hi Mike Your tip about q\\ worked. I'm totally new to Perl so i don't have the knowledge base that you guys have. I'm now going to try and work on getting the list of unique field names. many thanks kitty

Hi Mike Thanks for the tip about the single quote. I've tried it and now it's saying Substitution pattern not terminated at prints1.pl line 114. I guess it's choking on the apostrophe in the word Wyatt's Secondly, the data is in the format as shown in my original posting ie: each field...

Hi Three questions 1. I've got some data (see below) that contains @{}*, how would i escape these characters. I tried using quotemeta but but i get the following error messages if i try to print $testString. Possible unintended interpolation of @Rose in string at prints1.pl line 13...

Finally sorted the problem: I had to increase the text buffer in Coldfusion Administrator. It was set at 64,000 chars but i've upped it to 100,000 and that seems to have fixed the problem. Big thank you to everybody who replied.

Thanks for your reply mkal. 1. I checked out books online and it says under READTEXT that the varbinary must be set to 16. I tried increasing it anyway but it didn't make any difference. 2. I tried increasing the size used with READTEXT. The maximum it will work with is 41353 but even at...

I've got a document which is about 40,000 characters stored in an ntext field. I have used 'set @@textsize' in query analyser to increase my textsize. I have written a query : DECLARE @Val varbinary(16) SELECT @Val = TEXTPTR([DocumentXML]) FROM [tblDocument] WHERE [DocumentID] = '91'...

Hi James The maximum number of characters that you can set in query analyzer is 8192, butit's still truncating my document. kitty

Can anybody help me I have a document which appears to be too large for the ntext datatype. When i retrieve the document (using coldfusion or the query analyzer in SQL Server) it's truncated. Is there anything I can do?

I have roughly 400 images of varying sizes some portrait and some landscape. Is there a way I can run a batch process to resize them all so that the longest side whether portrait or landscape is 300 pixels. Kitty

The way I have handled this in the past is to put all the images into one folder called &quot;images&quot; and store them on the server. In the database i then enter a link to the image(s) eg: ../images/image1.jpg I hope this helps kitty

Can anybody help? I'm trying to open tables within sql server 2000 enterprise manager and I keep getting the following message: &quot;The query cannot be executed because some files are either missing or not registered. Run setup again to make sure the required fields are registered&quot; I...