How to concatenate strings

[victoria_1018]

Hi,
Does anyone know if I can concatenate string and then break it into table? (Using either ASP or VB Scripts)
If this is possible, how should I do it?
Thanks
Regards
Victoria

[whammy]

I can show you how to concatenate a string:

string = string & "whatever"

but I'm not sure what you mean by "break it into table". Can you be more specific?

[victoria_1018]

Here is the example to the string.

I am suppose to execute a stored procedure(1) and get
the results which is a list of centers which the user
have access rights to.
And using this list of centers, I will determine
whether they can view the job enquiries which they
want. Which means the job enquiries must be from the
SCC which they have been given the rights.
At present, the job enquiry can only verify the 1st
center record returned in the previous stored
procedure(1). And if the Job Enquiry is from the 2nd
center record returned, the access is denied.

Thanks

[dfrancis]

This is so hard not knowing the table structure... but in theory, here is how I would try to do it...

Procedure(1) Get list of centers user has access too...

rsCenters (or string)

Procedure(2) List of jobs from those centers (including access limitations)

Okay....

Query Center (p1)

sql = Select * from centers where authuser = userID

rsCenters(sql) = Returns list of all centers user is authorized for right?

Query jobs from list of auth centers (p2)

loop through jobs
sql2 = Select * from jobs where center = rsCenters(i) AND authuser = userID

rsJobs(sql2) = all jobs from auth centers where userid is authorized.


That help?

Yeah, you'll have to put a finer point on this in that I declared nothing and thoughts are a bit jumbled... but it's kind of a brain dump to help confus... eh... I mean help you if I can. :eek: ;)

[victoria_1018]

Thanks dfrancis,
I will try it out.