sequence

jQuery sortables

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 ...

Hibernate JPA Sequence (non-Id)

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...

Is it possible in SQL Server to create a function which could handle a sequence?

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....

What happens to an Oracle sequence after disaster recovery?

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. :-) ...

Best Way To Determine if a Sequence is in another sequence in Python

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):...

Regex Pattern - Allow alpha numeric, a bunch of special chars, but not a certain sequence of chars

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...

What tablespace are Oracle sequences stored in?

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, ...

How to write the sequence 1 0 1 0 0 1 0 0 0 1 0 0 0 0 1 0 0 0 0 0 in JAVA ?

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 ;) ...

[F#] Merge/join seq of seqs

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 ...

UML sequence diagram call property

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...

XML Entity for "/" ?

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 ...

Sequence Generators in T-SQL

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...

Howto Restart Loop in C++ (Finding Unique Sequence Over Random Runs)

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...

Compact way to extract parts of strings (FASTA header)

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...

Python sequence naming convention

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...

Oracle sequence but then in MS SQL Server

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...

How can I send terminal escape sequences in raw input mode?

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); ...

F# array_chunk for Sequence

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 ->...

How to write a C program using the fork() system call that generates the Fibonacci sequence in the child process.

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...

how to find missing value in sequence within groups in SQL?

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 ...