Search results for query: *

Hi folks, I would like to ask a question about application setting under "Home Directory" tab. By default, the application name is set to "Default Application". When I installed Crystal Report, they will create a virtual directory "crystalreportviewer" and the...

Hi folks, I am facing a headache problem about multi-language. Actually, I have two environments, 1 is development in local office another is production in client's office. I need to display English, Portuguese and T. Chinese. I don't have any problem in development oracle, no matter VB program...

Please try to check the "SQL Server Network Utility" to see whether you have to enable the TCPIP or not. Also, make sure the port 1433 is not blocked.

In order to check the recordset have record or not you should use If rs.eof and rs.bof Then if both are true that means really no record found. Your case may not be handle 1 record found.

Let's start from zero, can you print the ID after ID = conObj.Execute("SELECT @@Identity").Fields(0) Response.Write "ID:'" & ID & "'" If so, try to print the Sesion("ID") after set the ID Session("ID") = ID Response.Write "Session...

rjkealey, I have some hits for you to trace, 1. Are you sure the hosting server supports the provider you specificed? 2. What is the physical path of the mdb file you stored in hosting server? At localhost you stored to d:\home\default\cmkinc.biz\htdocs\auto\foreclosure.mdb How about...

Hi folks, Actually, I have some questions want to clarify. I have made a func.asp that contains a lot of common functions and reuse in many pages. Now, I am using <!-- #Include file=&quot;../include/func.asp&quot;--> and working fine. As I know, asp is also accept include virtual...

Hi Folks, Does anyone know how to make an ASP that can export report data automatically? I want to make an ASP export engine that allows me to pass report name and file type for export. That's not the problem, as I know how to do it. I have to download some sample code from CD web site and...

Actually, the page does not used session and I just want to prevent the visitor press &quot;back&quot; button to see the content. Basically, we have been done before but the code is missing. As I remember, it just set a few line in asp then can force the page expire by &quot;back&quot; button...

Hi folks, Does anyone know how to make the page expire when press &quot;back&quot; button? Any help is highly appreciated, thanks! Best, Tony

What is the provider you use in connection string? Are you using ADO? Please try following connection string, it works on my project but Oracle 8i Provider=OraOLEDB.Oracle.1;Password=yourpwrd;Persist Security Info=True;User ID=login;Data Source=[sia or service name] Good Luck! Tony

Yes, you could exchange any HTML control value through frame. Following is the syntax for passing data from Child to Parent frame. parent.frames['framename'].Fr.txtSample.value = '123'; parent.frames['framename'].divSample.innerHTML = '123'; also, you could get the value from there by, totPg...

I also think it might not strong enough for such heavy workload and thanks for your advice. I will try to take a look at virtual memory on the server. Yes, you right the server only has 1 physical disk drive. If upgrade is another alternative we will consider it. Would you please give me your...

Terry, CPU: PIII (Single CPU) RAM: 256M Ram Hard disk: 10G I have rebuilt all indexes and defrag all tables again but also take much time to finish. Temp table is also another good alternative for consideration. Thanks! Tony

Terry, Thanks for your advice on SQL turning. When I run the SQL it use 100% CPU loading on server. Does the SQL Server or Windows 2000 have any method to control the resources? Now, when the program generates report by above SQL then another users cannot run the program. ~_~' As I know...

Actually, I am a not sure do the SQL Server utilized the indexes but could be sure that I have to make the index on all primary keys. Below SQL statement is worked but just take some time to finish, talking about 3 hours at lease. While the SQL is running there is no any other application can...

Thanks, alfredp77!

Sorry, I am not really understand your question. Would you please explain more detail?

Sorry, you should join as follow select member_id, company.company_code, company.credit_limit system, member_id, first_name, last_name, members.credit_limit, members.email, date_sent, vwCount.total from Company, Members left outer join Reminders...

Assuming that your join condition is correct and you can try to use following SQL statement. I didn't put the Reminder to sub-query and just put it into if it is necessary. select member_id, company.company_code, company.credit_limit system, member_id, first_name...