[SQL] Design Problem...

2004-04-22 Thread Ryan Riehle
Our business has multiple cost/profit centers that I call business units, these are in a table called buinessunits. We also have a table that holds a list of services that are offerred by a business. Each business unit has many services it offers; 1 businees unit => Many Services. We want to be a

Re: [SQL] Strings in UDFs

2004-03-02 Thread Ryan Riehle
Y DEFINER; *** I removed the use of quote_literal() and had to put parenthesis around the criteria of the WHERE clause. hrmmm... why is this? does anyone know why it was giving me an error (s

[SQL] Strings in UDFs

2004-03-02 Thread Ryan Riehle
scaping the single-quotes very confusing and so far, frustrating. In addition to helping me with this problem, if anyone can give me some good advice / general guidelines to using strings in my functions, it will be greatly appreciated since I anticipate writing a lot of these soon; it