At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!
COURSE of the MONTH
15 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
VBScript Coding Syntax with SQL query
Posted on 2009-05-13
(Code1 Question) Am using file.write line to create row header to output results of sql query to csv file.
In the code, I need to separate the line for readability. Or can I use a str variable instead? How would I do that?
(Code2 Question) Am using SQL=SQL & to separate sql query in VBScript. Can I use a str variable instead? How would I do that?
In the code, I need to separate the line for readability. Or can I use a str variable instead? How would I do that?
(Code2 Question) Am using SQL=SQL & to separate sql query in VBScript. Can I use a str variable instead? How would I do that?
'Code1 Sample:
file.WriteLine ""CLASS"",""SCHOOLNUM"",""SCHLNAME"",""SECTION"",""COURSE"",""TITLE"" "
'would like to separate it: into 2 lines or use a variable. (such as strheader=?)
'Code2 Sample:
SQL="select blah, blah, blah, blah....."
SQL=SQL & "blah, blah, blah....."
Can I use a variable instead? (such as strsql=?)
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
5 Comments
First question, to seperate into two lines, can you not just do two write lines?
file.WriteLine ""CLASS"",""SCHOOLNUM"",""
file.WriteLine"SECTION"","
SQL is already a variable!
'Code2 Sample:
SQL="select blah, blah, blah, blah....."
SQL=SQL & "blah, blah, blah....."
Can I use a variable instead? (such as strsql=?)
file.WriteLine ""CLASS"",""SCHOOLNUM"",""
file.WriteLine"SECTION"","
SQL is already a variable!
'Code2 Sample:
SQL="select blah, blah, blah, blah....."
SQL=SQL & "blah, blah, blah....."
Can I use a variable instead? (such as strsql=?)
(1) Will separating into file.writeline 2x keep the entire row intact in the file?
(2) I understand about #2, but can't I declare
strsql="Select blah, blah, blah from table"
then use the strsql instead of all the lines of SQL=SQL& I would need with a big query?
Be patient with me; I'm a novice in this area. Thanks
(2) I understand about #2, but can't I declare
strsql="Select blah, blah, blah from table"
then use the strsql instead of all the lines of SQL=SQL& I would need with a big query?
Be patient with me; I'm a novice in this area. Thanks
(1) Ok, you mean in code you want to write in two lines but show as one line when written?
use .write instead of .writeline
file.write
then end with
file.writeline
(2) Do you mean you want to append a string?
use .write instead of .writeline
file.write
then end with
file.writeline
(2) Do you mean you want to append a string?
String concatenation can be done using & as you have done
strsql = "xxxx"
strsql = strsql & "yyyy"
Regarding (1)
And example
I use chr(34) to write a double quote
f.Write chr(34) & "CLASS" & chr(34) & "," & chr(34) & "SCHOOLNUM" & chr(34) & "," &
chr(34)
f.write "SCHLNAME" & chr(34) & "," & "SECTION" & chr(34) & "," & chr(34)
f.writeline "COURSE" & chr(34) & "," & chr(34) & "TITLE"
strsql = "xxxx"
strsql = strsql & "yyyy"
Regarding (1)
And example
I use chr(34) to write a double quote
f.Write chr(34) & "CLASS" & chr(34) & "," & chr(34) & "SCHOOLNUM" & chr(34) & "," &
chr(34)
f.write "SCHLNAME" & chr(34) & "," & "SECTION" & chr(34) & "," & chr(34)
f.writeline "COURSE" & chr(34) & "," & chr(34) & "TITLE"
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over the limited options we had scripting in Task Scheduler 1.0. As I started my journey of knowledge I f…
Confronted with some SQL you don't know can be a daunting task.
It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as:
(+) as used in Oracle; *= =* as used in Sybase …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Suggested Courses
Course of the Month15 days, 8 hours left to enroll
741 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.