Search results for query: *

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 ?

I've created a view that unions all the invoice table in child's database. However, it doesn't allow me to execute update statement from the view because it contains union operator. What's the most efficient way to update child's database ?

...will need to pull the data from multiple databases. What's the best way to achieve this ? All I can think of is construct the query like: select * from mydb1.dbo.mytable union select * from mydb2.dbo.mytable union select * from mydb3.dbo.mytable Is there any better way to do it ? In...

it's required by customer...

Would you mind providing some tips on how to create TIFF in VB 6.0 ?

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 ?

Ya, I think I can use that. If I have 2 relational tables - say 1 (master table) store order information such as customer name, address, etc, and another store items ordered. Order number is the key between 2 tables. When items table is updated, I need the timestamp on master table to be...

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.

Does it make any difference if the insert statement is inserting data directly into table ? I came across some articles before about insert data into views but can't remember exactly why.

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 ?

No. The web app is on our server. All customers are accessing the same web app and that's why our ASP must be able to configure depending on which customer logins at the time.

Is there any sample page that I can refer to using application_onstart() for form validation ?

We only need to make sure the field is filled, does not care the format of the data. However, we need to allow customer to define with fields they want to make mandatory. The only way I can think of is to store the fieldname selected by customer in a table. On page1.asp, build javascript...

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...

Everytime an SQL statement runs on a table, did SQL log it somewhere ? If yes, how can I view the log ?

Stored procedure still needs to have queries in it to pull data, right ? My question is: is it more efficient to create a view so the query will be like "select field1, field2,... from view1 where..." or more efficient to select from base table and join tables I need if there are 50,000 in one...

...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 from ASP ? Should I just add the...

got it to work. Thanks.

Actually, I have 3 invoice.asp - in common\, customer\, vendor\. The one under customer\ and vendor\ includes the one in common\, which contains the form and all invoices fields. The one under customer\ and vendor\ looks like this: <!-- include file="format.asp" --> <!-- include...