Re: Having two N plus 1 groups

2008-07-10 Thread John Dahl
Larry > > > On Thu, Jul 10, 2008 at 5:36 AM, John Dahl <[EMAIL PROTECTED]> > wrote: >> >> I am having similar problems but can't find any solution. >> Here is my case. >> >> report_group can have many report_types and many reports. No relation &

Re: Having two N plus 1 groups

2008-07-10 Thread John Dahl
I am having similar problems but can't find any solution. Here is my case. report_group can have many report_types and many reports. No relation exists for report_type and reports. Here is the result of a query to get a report_group. report_group_id report_id report_type_id 100

Re: Running dynamic sp

2007-08-01 Thread John Dahl
refully. If someone >> can set it to "drop table order;--" you're screwed. :-) >> >> Larry >> >> >> On 7/31/07, John Dahl <[EMAIL PROTECTED]> wrote: >> > >> > OK, I did it successfully with "$" operator. >> > One t

Re: Running dynamic sp

2007-07-31 Thread John Dahl
OK, I did it successfully with "$" operator. One thing I would like to know is can we prevent sql injection in this case. Thank you for the solution. John Dahl wrote: > > Ok, here is my requirement. I need to run different sp having different > parameters. For eg. I need t

Re: Running dynamic sp

2007-07-30 Thread John Dahl
gt; > call $sp_name$( #bill_id#) > > but then those two remaining two different method makes sense. > > regards > ashok > > On 7/29/07, John Dahl <[EMAIL PROTECTED]> wrote: >> >> >> Ok, here is my requirement. I need to run different sp ha

Running dynamic sp

2007-07-29 Thread John Dahl
Ok, here is my requirement. I need to run different sp having different parameters. For eg. I need to run following sps 1) call generate_bill( #bill_id#) 2) call generate_invoice(#invoice_id, #start_date#, #end_date#) Can I create a single method in sql methods with dynamic tags so that the same