RE: Testing Queries

Sat, 23 Mar 2002 20:58:36 -0800

Sorry Lee, I had things a little turned around.  I was looking for a QuerySim type test for the actual SQL queries whether they are SELECT, UPDATE, etc.   I did not know if there was a way to test them without having a database hook-up.
 
Thanks
-- Jeff
-----Original Message-----
From: Lee Borkman [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 23, 2002 4:51 PM
To: [EMAIL PROTECTED]
Subject: Re: Testing Queries

Hi Jeff,
 
I think you might have it a little mixed up.  QuerySims are not for testing queries.  They are for simulating queries, so you can test other fuses.  For example, if you have a fuse "dsp_userdetail" it probably expects a recordset as input - use a querysim to provide that recordset.
 
If you want to test a database update, you have to execute the update, and then do a SELECT to see if the data has changed.  I can't see any other way to proceed.
 
But if you are really asking "how can we also simulate other kinds of database accesses?", then you have me completely stumped, I'm afraid, because I can't see what that would actually mean.
 
Thanks, hope that's more helpful than annoying ;-)
 
LeeBB

Bjork.NET - Postcards gratefully accepted.

----- Original Message -----

Sent: Sunday, March 24, 2002 4:58 AM
Subject: Testing Queries

The QuerySim custom tag works great for testing select
queries, but how do you test an update query or any
query for that matter that does not generate output?

Thanks
Jeff ------=_NextPart_000_0085_01C1D319.6755BD80-- ${list_promo} 
==^================================================================
This email was sent to: [email protected]

EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9
Or send an email to: [EMAIL PROTECTED]

T O P I C A -- Register now to manage your mail!
http://www.topica.com/partner/tag02/register
==^================================================================

Reply via email to