Search results for query: *

Hello. I am trying to insert spaces into a column that is data type 'v'. I insert ' ' and when I look at the table data after the insert, the data value is <> instead of being spaces. Do any of you know how to get spaces into a V data type? Thanks for any and all help, gurus!! :)

Have you ever heard of a listbox (select) that stopped displaying any values in it? I have a production application that has not be changed in any way. The data, however has increased and there are huge amounts of data now being returned from the sql server database that are supposed to...

Hello. My stored procedure sp_Tx_Del_Maint works in query analyzer but the rows aren't being deleted when I call the sp from my asp page. I have displayed the input parameter value and it is correct. I have tried to execute working production stored procedures from my asp page and they don't...

Good morning everyone! I have looked and cannot find a way to rename a DTS package. Is it correct there is no rename capability in SQL Server 2000? Thanks! :)

Hello. Would one of you great people please help me? When I run this query, @score s/b 66.7 but 67 is printing (so I am assuming that the value that's being returned for @score = 67) but I can't figure out why. I appreciate your help, as always :) -------------------- Declare @s1 FLOAT...

Hello gurus. My brain is twisted trying to get this to work and I could really use your help, please. If there is a duplicate value for the max(chg_eff_date), then I must also use the max(sel_seq_nbr) to get the correct row. Here's the data, the results I need and my query (currently getting...

Good afternoon all. I've read the posted threads on this topic but none match my case and I'd really appreciate your help. I use coalesce in my search query which, until now, worked great because none of the columns in the search criteria were nullable. My new search criterion (sup_tso_id) is...

Hello. (background: this involves 2 include files that are saved as .asp files but are located in the INCLUDES folder). I have an include file (call it 'include1.ASP') that calls a sub which processes the display of error information by doing a response.redirect (with a query string to pass...

Hello. I'm stumped. Any help would be greatly appreciated. ]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]] Here's the code: Sub Display_Error_Page(lngErrorCode, strErrorDesc, strSub) Dim strMsg strMsg = strSub & "<BR>" & strErrorDesc -------begin comments 'this response.write is just to...

Hello. I posted this question under ASP and got no responses so maybe that was the wrong forum. I support (on-the-job training!) a web application written by other developers. I have to determine if the application is using the adodb.stream object on the client side. Can someone please tell...

Hello everyone. How can I tell if a web application is using the adodb stream object on the client? The clientside code is written in JavaScript. Thanks for help with this.

Good morning everyone! I haven't been able to find much info for this so I'd appreciate it if you sql gurus would confirm for me that the following is correct: I have a value (i.e. 2003-12-31) in a nullable date field (i.e. end_date) in a db2 table (i.e. Table1) and I want to replace the date...

Good morning. I don't understand what the advantage is of working in local mode? Could someone shed some light on this for me? I'd really appreciate because I might be missing out on a valuable feature since I don't understand the purpose. Thanks all..have a great day, weekend and holiday!!

Good afternoon all! I think I'm misunderstanding something. Someone told me that I can add an asp page to my application and, using the application object, I can display the data values of all of my application variables which would be invaluable for debugging in Production and QA where I...

Good afternoon everyone. Can/will the sql statement: Select max(start_date)where customer = 'ABC' return >1 row if there are multiple rows in the table that contain the highest date value? i.e. table data customer start_date ABC 2002-06-04 ABC...

Good afternoon all. My users want to change a value that's currently allowed as an integer to allow for 2 decimal places. Currently the attribute answer_value that's stored in the valid_answers table is data type int(4). The data type for answer_value in the question_data table = varchar(500)...

Good morning all! Thanks for any help and have a great day. Here's the issue: I have a Production problem with an asp page. I noticed that I used 'elseif' instead of 'else' for the two condition checks for "ElseIf sAuthCode = 4" and I was wondering if this could cause any logic problems...

Good afternoon. I have a general question regarding what types of problems can stem from undimmed vb script variables in an asp page. I'm having INTERMITTENT problems with an application in production and I currently don't have a way to view variable values in production. In the course of...

Good morning all. I just had my OS upgraded from Windows NT to Windows XP at work and now when I go into Interdev to work on my project I get this message: note: nFileName below = LOTS of files names - I'm getting this message for lots of files in my Interdev project You have a local copy of...

Hello everyone! I'm researching an application problem and have two basic questions: 1. Does it matter where on my asp page I put the <!-- #include file="Includes/Adovbs.inc" --> on the asp page? (i.e. does it matter if it's physically located on the asp page before the place or after the...