Search results for query: *

i am trying to return a qry on a ASP page and am getting the following error Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint. i am not trying to update the field the field is nvarchar 4000 and there are only 511 charactors?

im hoping someone can help.... instead of trying to get rid of whitespace i need to created them so when i return the results in a Qry if there are only 2 charactors it will force 2 white spaces at the end ?

could anybody help me i can not pass the variable \ between pages ?

Can anyone help me create a Yes / No option popup box ? i currently have ok/Cancel one if (confirm ("WARNING \nAre you sure this is is correct?") ) { document.FrmNew.Text1.value= 1 } else { document.FrmNew.Text1.value="" document.FrmNew.Text1.focus() }

Can any body help me force printing to landscape. i am currently using function doPrint() { window.print(); window.close(); } but i do not want the user to have to change the settings manually

Can any body help me force printing to landscape. i am currently using function doPrint() { window.print(); window.close(); } but i do not want the user to have to change the settings manually

I am trying to pass a variable from a text box on a asp page to a stored procedure ? any help would be great!

I am trying to wrap text on a button. Can anyone tell me if this is possible if so how ? thanks

Hi Can anyone help me with the code to upload excel files using asp?

I am trying to make a select box have 2 values from a RecordSet i have managed to do this but i am having trouble spacing the columns evenly i have tried to force the length of the first column but can only do this by inserting a chacator not spaces? Can anybody help me put spaces in or point...

I have created a DTS to import form an Excel Speadsheet into SQL When I execute the DTS from enterprise manager it works fine When I activate it via asp I get a error saying Step [DTSStep_DTSDataPumpTask_1] failed Task "Transform Data Task: undefined" Does anyone have any ideas im desperate !

I am trying to execute a DTS from a Stored Procedure in SQL 2000 Can any body help? Or any other way of importing Excel Spreadsheets from an asp page would be appreciated. Thanks

Can anyone help? I am creating a Temp file on my server and then allowing the user to download the CSV file to their local computer I am struggling when the data contains a comma though as this moves the data to a new cell in excel ? This is the code I am using dim fso, txtNew, txtNewName...

I am trying to export data from an asp page into a csv file. I can manage to export smaller files but as soon as anything over 20,000 records the first records are ok then I get this at the bottom off the page <p>Response object</font> <font face="Arial" size=2>error 'ASP 0100 ...

When exporting to XLS from a web page, if my recordset is below a thousand records, it works fine but when I have a larger recordset, it falls over and only exports a few fields and includes all of the formatting code as well. Can anyone help? [sadeyes]