I'm using the sortable function in jquery to sequence a faq list. Needless to say, i'm new to this concept. Anybody have any good examples of the backend for this. I have the front working fine, but updating the sequence in the database is another story. My backend is ColdFusion btw. Thanks in advance ...
Is it possible to use a DB sequence for some column that is not the identifier/is not part of a composite identifier? I'm using hibernate as jpa provider, and I have a table that has some columns that are generated values (using a sequence), although they are not part of the identifier. What I want is to use a sequence to create a new...
We are looking at various options in porting our persistence layer from Oracle to another database and one that we are looking at is MS SQL. However we use Oracle sequences throughout the code and because of this it seems moving will be a headache. I understand about @identity but that would be a massive overhaul of the persistence code....
Suppose an Oracle instance has to be recovered after a disaster. Do sequences get reset to the initial state, or the last saved state, or are cached values preserved? Thank you very much. :-) ...
This is a generalization of the "string contains substring" problem to (more) arbitrary types. Given an sequence (such as a list or tuple), what's the best way of determining whether another sequence is inside it? As a bonus, it should return the index of the element where the subsequence starts: Example usage (Sequence in Sequence):...
I have the following regex: (?!^[&#]$)^([A-Za-z0-9-'.,&@:?!()$#/\])$ So allow A-Z, a-Z, 0-9, and these special chars '.,&@:?!()$#/\ I want to NOT match if the following set of chars is encountered anywhere in the string in this order: &# When I run this regex with just "&#" as input, it does not match my pattern, I get an error...
The app my colleagues and I maintain has an Oracle database at the back-end. We're looking at occasionally running the app in a 'restricted' mode with one of the database tablespaces set to read-only. We can easily move the necessary tables and indexes over to separate tablespaces which will be writable in 'restricted' mode. However, ...
I'm currently beginning to program with Java. I tried to code the sequence in the title as an output in Java, but I'm stuck! I'm experimenting with the for function, any help is welcomed ;) ...
Slowly getting the hang of List matching and tail recursion, I needed a function which 'stitches' a list of lists together leaving off intermediate values (easier to show than explain): merge [[1;2;3];[3;4;5];[5;6;7]] //-> [1;2;3;4;5;6;7] The code for the List.merge function looks like this: ///Like concat, but removes first value of ...
In my app i have a Document class and a DocumentFact class. The DocumentFact class contains methods which will get multiple Documents from the database. These documents are stored in a datatable or dataset. Both (datatable, dataset) are private members of the documentfact class. They can be accessed via properties. Now my question is: i...
So I'm writing some XML generating code, and found that the following attribute value was screwing up the XML formatting: "Jim/Bob" So I looked into the XML Entities used as escape sequences and every list I saw did not include one for the forward slash. Am I missing something obvious here? Seems like the sort of thing you'd want to ...
We have an Oracle application that uses a standard pattern to populate surrogate keys. We have a series of extrinsic rows (that have specific values for the surrogate keys) and other rows that have intrinsic values. We use the following Oracle trigger snippet to determine what to do with the Surrogate key on insert: 'IF :NEW.SurrogateK...
Dear all, The following codes try to generate random strings over K runs. But we want the newly generated strings to be totally different with its reference string. For that I tried to use "continue" to restart the random string generation process. However it doesn't seem to work. What's wrong with my approach below? #include <iostre...
Hi, Given the following string: string Header =">day11:1:356617"; How do you extract everything except ">", yielding only: day11:1:356617 I could do standard loop over the string character and keep only other than ">". string nStr =""; for (int i=0; i < Header.size(); i++) { if (Header[i] != ">") { nStr = nStr + He...
Since there is no explicit typing in python, I want to be able to make the difference between sequences and non-sequences using a naming convention. I have been programming with python for a little while now, and I still haven't found any logical/practical way to name sequences. Of course, I went through the famous PEP8, and made some re...
In Oracle there is a mechanism to generate sequence numbers e.g.; CREATE SEQUENCE supplier_seq MINVALUE 1 MAXVALUE 999999999999999999999999999 START WITH 1 INCREMENT BY 1 CACHE 20; And then execute the statement supplier_seq.nextval to retrieve the next sequence number. How would you create the same functional...
I have a program that uses a terminal in raw mode and I want to move the cursor around. Where can I find the escape sequence for this and how can I send it to the terminal from inside my c program? Here's what I currently have: char code[4]; code[0] = 27; code[1] = 91; code[2] = '*'; code[3] = 'D'; write(1, code, 4); ...
I'm having some trouble making a sequence. Basically I need to chop a sequence into a sequence of arrays. Seq.windowed almost does it but I don't want duplicate elements. I can get what I want by reading everything into an array first but I'd rather use a sequence. let array_chunk s (a:int[]) = Array.init (a.Length / s) (fun i ->...
The problem I am having is that when say for instance the user enters 7, then the display shows: 0 11 2 3 5 8 13 21 child ends. I cannot seem to figure out how to fix the 11 and why is it displaying that many numbers in the sequence! Can anyone help? The number of the sequence will be provided in the command line. For example, if 5 i...
i have a table of IDs and positions CREATE TABLE #MissingSequence (ID INT NOT NULL, Position INT NOT NULL) INSERT INTO #MissingSequence (ID,Position) SELECT 36,1 UNION ALL SELECT 36,2 UNION ALL SELECT 36,3 UNION ALL SELECT 36,4 UNION ALL SELECT 36,5 UNION ALL SELECT 36,6 UNION ALL SELECT 44,1 UNION ALL SELECT 44,3 UNION ALL SELECT 44,4 ...