Hello Thorpe, Im not sure if this question is related to Naviserver. It
looks like you have more application logic error or smth.
As I understood from your email its 2 lines you get from DB or smth,
shopping_cart_id looks identical ( 186467 186467 --- may be it is a
typo), but try to check your code, may be use dict, for example when you
run query get resul as a dict in format "column_name" "value" etc.
Im pretty sure it has nothing to do with TDBC or Naviserver.
Maksym Zinchenko
On Sat, Aug 15, 2020 at 7:54 PM THORPE MAYES via naviserver-devel <
naviserver-devel@lists.sourceforge.net> wrote:
> HI,
>
> I am using TDBC to connect to a postgresql database.
>
> I am getting strange behavior with a tcl foreach statement.
>
> Here is the list I am stepping through:
>
> LIST: {186467 2225 1 122 771 {6 inch Ham Sub} 1 5.75 t {Plain no cheese}
> t White t Chips f {} {}} {186467 2225 2 13 1192 {Smoothie with chips} 1
> 5.50 t strawberry f {} f {} f {} {}}
>
> The first element in each sub-list in the list is the shopping_cart_id
>
> When I move through the list I assign values to variables using lassign
>
> Every once and a while the variables are not assigned values. For example,
> I get an error saying that shopping_cart_id does not exist when I try to
> use in in the foreach loop.
>
> I have never had this issue before.
>
> The major difference in this project is that I am using TDBC to connect to
> the database.
>
> Is there a problem with TDBC that might cause this behavior?
>
> Thank you.
>
> Thorpe
> _______________________________________________
> naviserver-devel mailing list
> naviserver-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/naviserver-devel
>
_______________________________________________
naviserver-devel mailing list
naviserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/naviserver-devel
