Tagged Questions
0
votes
1answer
12 views
how can i create a pivot table with classic ASP vb
Can someone please please help me out.
Im trying to do something that looks pretty simple and easy. But i can't seem to figure it out.
Im trying to display my data as a pivot table in stead of the ...
-1
votes
0answers
76 views
Data provider or other service returned an E_FAIL status - ERROR
I'm trying to run an asp webpage and I'm using vbscript. I have an SQL query to gather a collection of records and then I need them outputing into a table on the page. Sounds pretty straight forward ...
1
vote
3answers
72 views
Missing value from variable
I'm trying to populate a <select> with <option>'s on a site with Classic ASP/VBScript. The values are read and taken from an SQL Server Database and the code for that looks similar to:
...
-3
votes
0answers
36 views
Managing FTP with VBS [closed]
I'm trying to use ActiveXperts Network Component for managing FTP, but am getting the following error:
How to upload a file in specific directory of FTP after suitable data are provided?
0
votes
1answer
35 views
Sending SQL query with reading from text file
http://myitforum.com/cs2/blogs/dhite/archive/2008/05/26/vbs-script-to-send-sql-queries-for-installed-collections-to-excel.aspx
Not answering because this is about VBS to Excel.
Valid SQL query fails ...
0
votes
1answer
49 views
Convert Sql query into vb script
I have the below SQL query. I wanted to execute the same query in vbscript, but am not able convert it and not getting proper result. Can I get the correct convert format?
SELECT distinct CASE
WHEN ...
-1
votes
1answer
37 views
how to use vb variable in SQL statement in ASP?
How to use variables declared in the asp VB can be used in the SQL statement for classic ASP?
Problem:
I have a variable
dim username
username = Request.Form("username")
Now I want to use this ...
0
votes
1answer
62 views
Query timeout expired - ASP Classic (VB). Timeout happens in client browser, not on server
I'm having some troubles with timeouts on my website. It has a rather large newsletter receiverlist (approx. 100k recievers). We deliver a tool for sending out newsletters, and based on the query for ...
0
votes
2answers
116 views
Return a value from stored procedure classic asp
As a noob to stored procedures, I can't get my head around how to get a classic ASP (vbscript) page to return a value from a stored procedure. I can write data to a table ok, it's just retrieving ...
1
vote
1answer
44 views
VBscript for adodb query
I need to add a few lines to our billing system, and I don't know enough about the syntax of this call. Can someone tell me what the zero's in the first line of this query means?
strSqlStmt = ...
0
votes
1answer
170 views
How to insert NULL value into datetime field via stored procedure
I've searched for answers to this, but none I've found have really helped. I have a stored procedure that writes data to a table. The insert includes a DateTime field, but this field can be empty ...
1
vote
1answer
182 views
Get Row number of excel using ADO
We are trying to get the row number of particular recordset retreived based on soome condtion. consider below table
Name Id
abc 1
cde 2
efg 3
Now, how to get the row number or ...
3
votes
1answer
616 views
Using excels named range/ object in a sql string VBScript
( I have edited this questions, see below ) I have searched on here and google but I still cannot solve my issue. I am trying to use an excel's named range equivalent in my .vbs file. This below works ...
0
votes
0answers
76 views
VBScript Converting csv to xls not working…
I have this VBscript that I want to run from SQL but it is hanging. Can anyone help me figure out what is wrong?
IF WScript.Arguments.Count < 2 Then
Wscript.Quit
END IF
DIM ...
0
votes
4answers
112 views
SQL - Query using Join / Having / Subquery - How
Please suggest a sql query to fetch the
"list of students and corresponding subject in which student has same score , if the student has same score in more than one subject"
eg.
Student Subject ...
