webdb | JavaScript plugin which make it easy to use WebSQL feature | Plugin library

Can anyone help? How to count data from the "web" database Sitecore?

I don't understand what undef is doing in this snippet:

I've been able to setup my Visual Studio (2019) Database Project up and using database references fine for tables, stored procedures, views, etc. They all seem to match up fine with the schema I've imported. However, I can't seem to avoid errors when it comes to referencing the same database's contracts, types, services, etc. When I reference the target database's service I have no issue (I assume this is because it accepts basic NVARCHAR strings versus a strongly-typed schema.

I've got the following example that just sends a message to another database's service. I get the error: "SQL71502: Procedure: [dbo].[z_Queue_SendMessage] has an unresolved reference to object [@VariableName]" with @VariableName being all of the following: (@RequestMessageType, @BasicContract, @InitiatorService)

I have a problem with encoding in ORACLE APEX app builder. When I'm using a app builder and creating for example a list with entry with polish native chars for example "Otwórz". When i save it it appears on list as "OtwA3rz". So I'm thinking about problem with encoding, but when i use "Grid Edit" on list I can easily use "Otwórz" and save it properly. After that there is a problem with edit this entry in form. Additionally when I create a form with for example textarea in my app there is no problem to save a value with polish chars. There is only a problem with app builder.

Some info from "About Application Express" modul:

• Product Build 19.2.0.00.18

• Schema Compatibility 2019.10.04

• Last DDL Time 02/05/2020 01:09:01 PM

• Host Schema APEX_PUBLIC_USER

• Application Owner APEX_190200

• Language Preference en

• Current Time (on server) 03/16/2020 02:17:08 PM +01:00

• APEX_LISTENER_VERSION 19.2.0.r1991647

• PLSQL_GATEWAY WebDb

• GATEWAY_IVERSION 3

• SERVER_SOFTWARE Mod-Apex

• GATEWAY_INTERFACE CGI/1.1

• REQUEST_METHOD GET

• QUERY_STRING p=4350:9:956788024708&p_dialog_cs=e6pVbBxXQReCPpEOwNEhrbAjoGPeY7nX6VVuLL8ObTSnXKlihOrJCOR8f1EU9isYxMT5Ooqgb-j9A33Mmx1aKA

• PATH_INFO /f

• HTTP_USER_AGENT Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36

• HTTP_ACCEPT_ENCODING gzip, deflate, br

• HTTP_ACCEPT_LANGUAGE pl-PL,pl;q=0.9,en-US;q=0.8,en;q=0.7

• REQUEST_CHARSET AL32UTF8

• REQUEST_IANA_CHARSET UTF-8 • Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

• CORE 12.2.0.1.0 Production

• NLSRTL Version 12.2.0.1.0 - Production

• PL/SQL Release 12.2.0.1.0 - Production

• TNS for Linux: Version 12.2.0.1.0 - Production

• NLS_CHARACTERSET: EE8MSWIN1250

• DAD CHARACTERSET: UTF-8

• JOB_QUEUE_PROCESSES: 15

I noticed that when I run a sql select 'ó' from dual the result is exactly 'A3'. I run another select * from V$NLS_PARAMETERS; and maybe find a reason of all of this. NLS_LANGUAGE is AMERICAN. How to change it for POLISH like I have normally database session configured. When I create my own app with globalization setting there is no problem with setting nls_language to Polish. But i don't know how to change it for app builder

I made a additional experiment i run insert into table value 'ł' and select * from v$nls_parameters thru sql_workshop and sql_script: and below are results: (syntax parameter:value:method(script or sqlworkshop))

I have a 'Catch Reporting' form for our local fishing club and currently users can only submit one catch at a time so often have to go back to the form multiple times to report a day's catches.

I'm trying to adapt it so that the Species list becomes a multiple option select box instead.

Each catch needs to be its own row in the database.

This is the user-facing form which I have changed from a Select to Select Multiple:

i want to update privacy of a post

my controller

I got this message, and I couldn't find any error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where id ='null'' at line 1

I assumed this code was wrong, but it turned out it isn't.

We experienced an error in our code that was executed in SQL Server 2014 which we do not encounter in SQL Server 2008 R2.

Our code is like this:

I have a xml file, I want to repace the text value in the tag < jdbcurl > with another value, but there are two tags named with jdbcurl nested in different pool id.

Can any one do me a favor to dig it with SED? Thanks.