Skip to content

Posts...

Page 33 of 42

PostgreSQL: Call a Stored Procedure for Every Row

May 13, 2014Category: Software
I guess that newbies in PostgreSQL like me have first question when they create a store procedure: How do I call it? The answer is simple; you just execute Then, usually immediately the second question pops up: I wrote a procedure which I need to call for each row in a table. How do I do that? The…

Formless Step in FormWizard

May 7, 2014Category: Software
Sometimes you'd need to show a purely informational page as part of a FormWizard. As far as I could see, there are two solutions to the problem: If the info is something like a summary, you have it available in the "success" page (the one after the wizard is finished) Alternatively, you can make it…

Create Data Once in a FormWizard

May 6, 2014Category: Software
At one of the sites I'm building I need to walk users through a registration process: Select a supported tool Generate an ID Create a configuration based on the previous two steps To do this, I chose to use a FormWizard with three steps, one for each of the above. The problem then becomes to…

Drawing QR-Code on Browser in Javascript

May 2, 2014Category: Software
In my quest to make the pages of one site a bit more mobile-friendly, I've got the idea to provide a QR-Code for an unique identifier generated for users. This is part of a wizard and the end-product is: QR Code in JavaScript To reach this outcome, I've started by looking for a QR javascript snippet…

Copy Text to Clipboard in HTML Page using JavaScript

May 1, 2014Category: Software
I've got a problem on one of my sites: I have a unique identifier displayed on one page, which I need to make it easy After looking online, I've found three approaches using only JS. Clipboard.js Clipboard.js is a new (September 2015) approach which uses only JS to copy the text transparently…

Send POST to server via python-requests

April 15, 2014Category: Software
The other day I've had a question asked: How do you send a form data to a server and get the reply? My solution involves python-requests : r.text contains the reply HTML page, which then needs to be processed via e.g. python's DOM processing module or BeautifulSoup (if you're looking for…

Loading XSDs into Oracle through Python

April 2, 2014Category: Software
Following the previous incursions in Oracle and their own documentation, we decided it was useful to attach schemas to the inserted data, just because only XML with schemas attached can be indexed. When you have some million entries, indexing seems like a good idea (once you decide what to index…

Use Oracle's RegisterSchema with Large Schemas (from Python)

April 1, 2014Category: Software
An important note when loading XSDs in Oracle is that DBMS XMLSCHEMA.registerSchema() requires the actual content of the _ xsd is loaded in a string. A side effect is that strings in Oracle have limits and schemas can exceed those limits. Therefore, such strings must be fragmented. In this case…

Drop an Oracle-Loaded XSD in Python

March 31, 2014Category: Software
A loaded schema can be dropped if: No other schema depends on it No data using the schema is loaded I think you may force unloading schemas even if there is data loaded but I haven't tried that. The code to drop a schema is: You can use it if e.g. schema is updated or we don't need it anymore. The…

Loading Dependent XSDs in Oracle through Python

March 31, 2014Category: Software
One essential feature is that schemas can refer to other schemas. Oracle supports it via the schemaURL parameter. In other words, the url of the referred schema must be the same as the schemaURL parameter used to register the referred schema. One consequence of this feature is the necessity to…
PreviousNext

All tags