RE: Dynamic queries v/s Stored Procs

2006-02-28 Thread rtroiana
sql string embedded in C# code? Thanks, Reema -Original Message- From: James Black [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 10:54 AM To: rtroiana Subject: Re: Dynamic queries v/s Stored Procs -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 rtroiana wrote: > Al

Dynamic queries v/s Stored Procs

2006-02-28 Thread rtroiana
I'm in a process of transitioning from dynamic queries that were generated in C# code to using Stored Procedures. Although i haven't done any analysis of time difference between the two. But i do have few reasons to move to stored procedures: 1) I work on a security application and

Re: Dynamic Queries followup

2004-08-25 Thread SGreen
Red Hat > 15 MySQL > 15 Oracle 9 > > I think this is right. Please let me know what you > think. > > Stuart > > > > > --- Rhino <[EMAIL PROTECTED]> wrote: > > > This note is a followup to the thread entitled > > &qu

Re: Dynamic Queries followup

2004-08-23 Thread Stuart Felenstein
Cisco 15 Red Hat 15 MySQL 15 Oracle 9 I think this is right. Please let me know what you think. Stuart --- Rhino <[EMAIL PROTECTED]> wrote: > This note is a followup to the thread entitled > "Dynamic Queries" which was init

Re: Dynamic Queries

2004-08-22 Thread Stuart Felenstein
I think I failed to make something clear. The form and table that has the multiple selections from one category into multiple columns / same category is where users are inserting information. Hope this helps. Stuart --- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > Rhino, > First, thank you f

Re: Dynamic Queries

2004-08-22 Thread Stuart Felenstein
Rhino, First, thank you for the great response. Also, sorry cause on the reply , Yahoo was truncating the part I wanted to reply about. Anyway, yes it was the second case. I ask a user to pick 5 colors, so in my table I have fields In my uneducated mind I "thought" that would make for

Re: Dynamic Queries

2004-08-22 Thread Rhino
- Original Message - From: "Stuart Felenstein" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 22, 2004 7:32 AM Subject: Dynamic Queries > Not sure what to call what I'm attempting to do, > decided on dynamic queries. I should ment

Dynamic Queries

2004-08-22 Thread Stuart Felenstein
Not sure what to call what I'm attempting to do, decided on dynamic queries. I should mention that I've been working with databases for just a little over a month. Example could be many web sites, but let's say Expedia (the travel site..booking flights, cars, etc) My understaning