Andel,
Maybe you can try this snippet code:
<%
' For example the file name is thissite.asp
act = request("act")
if isEmpty(act) then
act = "act1"
end if
select case act
case "act1"
act1
case "confirm"
confirm
end select
sub act1
%>
<form...
B827,
Hi, Thanks for your help. But I still confuse with the command :
- objExcel.ActiveSheet.Cells(i + 1, 1 ) = "Wk No" & rs("WEEK_NO")
What is 'i + 1' means? does it indicate a column?
What about 1?
- objExcel.ActiveSheet.Range("A1:A1").Value = "Week...
All,
Hi, after I use query in my database, I want to write it in a text file or .xls file or maybe .csv file. How to do it? And after that How to download it or attach to send it through e-mail?
A snippet code would be helpful.
Thanks,
Vincent.
Hi All,
I try to use response.redirect but why does this error happen?
-- ERROR --
Response object error 'ASP 0156 : 80004005'
Header Error
/wtsrv/reportwwmm/rep_ww.asp, line 251
The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before...
Thanks 1209. It works.
How to connect it to MS SQL without password?
Should I write :
<input type=hidden name=user0 value="sa">
<input type=hidden name=password0 value="sa">
OR
<input type=hidden name=user0 value="sa">
Thanks,
Vincent.
Hi all,
How to call a stored procedure in MS SQL Server from an ASP. I try this code, but it's generate an error.
Code:
set rs = conn1.execute("TEMaster.dbo.CP_PtBrg " & qqakh & "," & usr)
Error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC...
Hi,
If you just wanna upload your file try this command.
path = "C:\project\enable disable barang\"
File = path & "filename.ext"
Set fs = CreateObject("Scripting.FileSystemObject")
if fs.fileExists(File) then
fs.deletefile file
end if
Set SU =...
You may try this code:
path = "directory/name"
File = path & "file name on server"
Set fs = CreateObject("Scripting.FileSystemObject")
if fs.fileExists(File) then
fs.deletefile file
end if
Set SU = Server.CreateObject("aspSmartUpload.SmartUpload")...
You may try this code:
path = "directory/name"
File = path & "file name on server"
Set fs = CreateObject("Scripting.FileSystemObject")
if fs.fileExists(File) then
fs.deletefile file
end if
Set SU = Server.CreateObject("aspSmartUpload.SmartUpload")...
You may try this code:
path = "directory/name"
File = path & "file name on server"
Set fs = CreateObject("Scripting.FileSystemObject")
if fs.fileExists(File) then
fs.deletefile file
end if
Set SU = Server.CreateObject("aspSmartUpload.SmartUpload")...
Hi All,
How to set the printer device from the script? I used to set the printer from the report File menu | Page Setup. Can I set it through the program?
Thanks,
Vincent.
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.