Search results for query: *

Yes, I've only selected fields in my query. My sql stmt has filters and 10K records are the final result after filters.

Hello, I need experts advise...I've an ASP page which is retriving 10,000 database records and it's taking too long to execute. how do I make it faster. I used response.buffer=true and response.flush methods but no change. Thanks in advance.

Hello All, How do I create auto number in SQL Server (similar to autonumber in MS-Acces and generating a sequence in oracle). In my code I have a field Emp_No which needs be generated automatically every time we insert a record in to the table.Any help is appreciated. thanks in advance.

Thanx pete, That wouldn't help me.

Hi , I've an ASP page which is retrieving all the records from the database. I would like to provide an option to the users that they can edit any record and save the changes in to the database. How do I write dynamic update statement to update that particular record user choose to edit. Any...

Thanks, jim! I tried it, but I got a message that I can't install with in the same partition. I've no partitions in the disc.

How do I install Xppro with out upgrading from XP home? I already upgraded from XP home to XP pro, but having problem with Intenet connection. Now I would like to cleanup my laptop and install XP pro. I've only one partition (C Drive) and I'm very much new to formating the disc. Any help is...

I've an assignment in which I've to write an ASP Script to import data from Excel sheet. I've never done this before, could anyone help me with this. Thanks.

Hello All, I've no idea of creating graphs in web applications (asp). I would really applreciate if you could give me some ideas. Thanks in advance.

markallen2 & bilsten, I tried everything, but I couldn't rectify the problem. I would really appreciate if you could help me out with this problem. Thanks.

Hello, Can some one help me in writing code to combine First Name and Last name and display. Thanks

I've AOL & MSN. When I use AOL the moment I login it says "error occured in your intenet connection, exit the application and restart". When I use MSN it doesn't even allow me to login, says "unable to provide MSN service/error in your system". I tried to setup new...

Thanks bilsten, It's a modem dialing up to an ISP. I'm not on a network, it's a stand alone (using at home) laptop.

Hello All, I did upgrade from XP home to XP pro on my notebook. I don't know what's wrong with it, I'm not able to connect to the Internet since I upgraded. Can somebody help me with this problem. Thanks in advance.

Hello All, I'm trying to create a login page with Username listbox,password and I have a table which is storing the records for Username and pwd. I'm loading the username values into listbox and when I'm typing the password I want to check with the corresponding password in the database. Any...

Thanks for your help, le'me try that code.

Hello All, I've been writing Oracle triggers, but I'm very much new to SQLServer. Can some one help me in writing Triggers in SQLServer, is it similar to Oracle. I'm trying to witre a gtrigger on table called TRUCK,when TRK_IS_ACTIVE='F' I want to update the field TRK_STOP_DATE to SYSDATE...

Thanks Allan, I'm able to create a trigger with your help. But when I'm trying to update the table it's giving me an error. ERROR at line 1: ORA-04091: table KEITH.CREW is mutating, trigger/function may not see it ORA-06512: at "KEITH.BU_R_ON_CREW", line 3 ORA-04088: error during...

I'm trying to witr a gtrigger on table called TRUCK,when TRK_IS_ACTIVE='F' I want to update s field TRK_STOP_DATE to SYSDATE. CREATE OR REPLACE TRIGGER UPDATETRUCK BEFORE UPDATE OF TRK_IS_ACTIVE ON TRUCK BEGIN IF TRK_IS_ACTIVE = 'F' THEN UPDATE TRUCK SET...

Hello All, I'm trying to install Visual Interdev on WinXp home, but it's not opening the application. As soon as I open any application with Interdev, it's closing the window. I'm wondering whether I need to have any webserver to work with interdev (I don't have IIS or Apache webserver) on Xp...