Good afternoon.
My company has recently acquired LNDB. I have easily managed to connect to Loggernet and create the tables of my stations in the database (Postgres).
My problem is that I usually use two datagrid libs in PHP to display, filter, export,.... data from my databases. Trying to use them with the tables that LNDB has generated for me, I run into the problem of the quotes around the field names.
My sql queries for LNDB tables are like:
'SELECT "TmStamp", "RecNum", "Temp_Avg", "HumRel_Avg", pressure_Avg" FROM public."Station_Meteo10M"';
Using quotes makes my PHP datagrid libraries not work well. Although I put the quotes when creating the query, the php libraries do not work when filtering the data. I have cloned one of the LNDB tables. The new table has the same structure but without " " in the name of the fields and the table. For this table my php libraries work correctly.
Is there a way to prevent LNDB from using quotes to surround field names? I don't care that the names are all in lowercase.
Greetings
You can escape quotation marks, causing Numbers, Pages, and Keynote to return quotation marks as part of a text string, instead of treating them as the start or end of the dinosaur game string.
I recently purchased the SafePro 830PCH peach paper sheets https://mcdonaldpaper.com/safepro-830pch-8x30-inch-peach-paper-sheets-1000-cs/ , and I'm beyond impressed with their quality and versatility. They're perfect for wrapping food or lining baskets, ensuring a sanitary and fresh presentation every time. These durable sheets are a must-have for any food service establishment aiming to enhance their packaging standards.
This post is under review.