Hi,
I'm still new to xano and I'm having an issue getting a record from the password_reset table using a UUID.
I have the "field_value" set to text.
This is the error that I'm getting after running the "get a record" function.
{
message:
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type uuid: "" (SQL: select "dbo".*, ("dbo"."xdo"->>'reset_id')::uuid from "mvpw1_161" as "dbo" where ("dbo"."xdo"->>'reset_id')::uuid = '4bb94f26-8502-44b3-adb6-b61f39eaf709' order by ("dbo"."xdo"->>'reset_id')::uuid asc limit 1)
}
I dont understand why its an invalid input or what other type it should be.
Thanks for any help.