I have an ASP page that allows user to browse to a file on local machine or mapped drive, then open it. If the file is on local c:\, ASP will try to look for the c:\ on server, instead of c:\ on user machine. How can I fix it ?
Each customer has one database in my system. Customer can login from a front-end ASP site to view data in their database. Now I want to setup a "super login" who can view the data in all databases. Some of the reports will need to pull the data from multiple databases. What's the best way to...
Is there a way to create a Tiff image using visual basic 6.0 ? I have a database of sales order information. I want to create an order sheet for each order and save it as tiff image on my server. How can this be done ?
I have a date/time field in one table. Is there a way to make this date/time field auto-updated to current date/time whenever the row is updated ? I have queries everywhere to update this table so change the query to update date/time field is not an option for me. Please help.
Is there a limit of how many rows of data can be in a table ? We have a web form with SQL statement to insert data directly to a table. It produces timeout error once a while after table reaches 300,000+ rows. Is it because the table size reaches the limit ?
What's the best way to do dynamic format validation ? I have an ASP (page1.asp) that can be accessed by multiple clients and a setting page for clients to define which fields on page1.asp is mandatory. What's the best way to do this kind of form validation ?
I have an ASP page (page1.asp) to gather information to be passed to a 3rd party JSP(process.jsp) page for data processing. 3rd party will return value to my ASP page (page2.asp). Is there a way I can create a DLL to pass all data to page1.asp for formatting and process everything, and then...
I want to pull a report that will join multiple tables (around 4 tables. some from same database and some from different databases) and perform some simple calculation such as field A * field B. Say there are 50,000 entries in the main table. Which way is the most efficient way to pull report...
My web folder has 3 subfolders - common\ and customer\ and vendor\. I have 2 invoice.asp pages, one in customer\ and one in vendor\ which looks like:
<!-- include file="format.asp" -->
<!-- include virtual="\common\invoice.asp" -->
<!-- include file="addbottom.asp" -->
invoice.asp has a form...
I have a page (main.asp) in root folder that will call a page in another folder. The root folder page looks like :
<!-- include file="format.asp" -->
<!-- include virtual="\common\invoice.asp" -->
<!-- include file="addbottom.asp" -->
\Common\invoice.asp is a form and will be submitted to...
My website has 2 types of user setup - customer and seller. My server has 1 folder with all ASP available to customer and 1 folder for seller. There are some pages (view invoice) common to both users that I wish to put into a common folder so I only keep 1 source code. Customer and seller can...
I've created a DLL that will initiate DTS, then have a ASP to call the DLL. The DLL is tested fine. However, when I run the ASP, it kept having "Invalid class string" error. What could be the problem ?
I try to create a DTS package that will export data from several tables into a coma delimiter file. What I did is create a connection to database, then a destination file object, then create a transform data task between the 2 objects. The transform data task will execute a stored procedure to...
What's the best way to send email from VB 6.0 ? I tried CDO but it won't work if there is attachment with file size > 4M. I tried outlook but it works in 1 server but not the other. Below are the codes for outlook. It errors out in .send:
Set objMail = appOutlook.CreateItem(0)
objMail.To...
I have 3 tables to join together. Table 1 has 1 row (always 1 row), table 2 has 2 and table 3 has 3. Instead of producing 6 rows, is it possible to produce only 3 rows ?
eg. table 1
inv=123
table 2
inv=123 item=1
inv=123 item=2
table 3
inv=123 date=5/12/03
inv=123 date=5/13/03...
My current ASP is calling DLL (written in VB6) and return confirmation page after DLL finished processing. DLL will be sending email with information requested. Sometimes DLL is taking long time to process and I don't want user to wait forever. Is there a way for ASP to initiate and pass...
I kept getting permission denied error when recompile DLL. This DLL is called from an ASP page. I tried remove DLL from component services, and click "Unload" button on website property in IIS but none of them work. The only thing that seems to work is reboot the server. Can someone help ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.