forgot the "]" at the end. Fred
On Fri, Apr 13, 2012 at 12:06 AM, Fred Taylor <[email protected]> wrote: > It does sound like your string is too long. Build it up in parts, not all > of it can be between one set of quotation marks. Maximum between quotes is > 255 chars. > > m.cSQL = [insert into food ]+; > [(FoodID,CategoryID,CompanyID,]+; > [UserID,Name)]+; > [ values ]+; > [(?lnFoodId,?lnCategoryId,?lnCompanyId,]+; > [?lnUserId,?lcName)] > > Fred > > > > On Thu, Apr 12, 2012 at 9:43 PM, Michael Oke, II <[email protected]> wrote: > >> Not tonight. It's at the office and, fortunately, I am not. It's roughly >> 26 fields, mostly numeric. >> >> >> Michael Oke, II >> 661-349-6221 >> >> Contents of this and all messages are intended for their designated >> recipient. >> >> On Apr 12, 2012, at 8:51 PM, Stephen Russell <[email protected]> >> wrote: >> >> > On Thu, Apr 12, 2012 at 10:33 PM, Michael Oke, II <[email protected]> >> wrote: >> >> Although you might think so, it is not. There is another field, >> FoodKey, that is auto-incrementing. In this case, lnFoodId has a value of 0. >> > ----------------- >> > >> > great. Now can you give us the entire string? >> > >> >> >> >> >> >> Michael Oke, II >> >> 661-349-6221 >> >> >> >> Contents of this and all messages are intended for their designated >> recipient. >> >> >> >> On Apr 12, 2012, at 8:11 PM, Stephen Russell <[email protected]> >> wrote: >> >> >> >>> On Thu, Apr 12, 2012 at 6:50 PM, Michael Oke, II <[email protected]> >> wrote: >> >>>> "insert into food (FoodID,CategoryID,CompanyID,UserID,Name) values >> (?lnFoodId,?lnCategoryId,?lnCompanyId,?lnUserId,?lcName) >> >>>> >> >>>> String is longer but that gives you the basics. >> >>> --------------- >> >>> >> >>> Came to the party late. >> >>> >> >>> how are you generating ?lnFoodId, That is a primary key I believe.. >> >>> >> >>> >> >>> -- >> >>> Stephen Russell >> >>> >> >>> 901.246-0159 cell >> >>> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbksqdpdud9h4h3qyqzu6yztoiykkw58f0h94up61cpnr...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
