RE: [sqr-users] Run PS Query in SQR

["Aleksandra Gacevic" <AGacevic@scu.edu>]

Hi Richard,

My problem is how to get a list of students, when sql that returns the list is, 
let's say, stored in one single variable, $sql. Another problem is how to get 
the sql in that variable, when all I have is bunch of query tables, one storing 
records involved, other fields, third criteria, forth prompt values etc., and 
they all have to be combined in order to build the sql itself.

Thanks.

Aleksandra

>>> KnappR@umsystem.edu 03/05/03 11:01AM >>>

I don't understand what query tool tables are so maybe I don't understand your 
question but what I think I understand about your question is:  You want to 
send e-mail to some students.  You are going to make a list of student's in 
SQR.  I assume the SQR will also be getting their e-mail addresses, no?  At the 
point in your SQR where the addresses are returned, I would branch to a 
procedure that assembled an operating system e-mail command based on the 
address and whatever other information you have.  I would then call system 
using that command.

If the text of the message varies with each e-mail, you can write that text out 
first and send it as a file overwriting the text for each e-mail.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu 


-----Original Message-----
From: Aleksandra Gacevic [mailto:AGacevic@scu.edu] 
Sent: Wednesday, March 05, 2003 12:34 PM
To: sqr-users@sqrug.org 
Subject: [sqr-users] Run PS Query in SQR


Hi,

I'm planning to use SQR to send email to every student whose emplid shows up in 
the query (from PS Query) provided by user. Even if I manage to build sql from 
Query tool tables (it will be tricky, anyone did it?), I will have totally 
dynamic sql to run in SQR. It will be select query, and will have variable 
number of columns (with unknown types) and tables involved. 

Do you think it's doable? Any suggestions would be appreciated...



Aleksandra Gacevic
Programmer/Analyst
Santa Clara University
408 551 7124


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users