Support Forum

My project was completed and went live last year, so thank you for your help in achieving this. I now have a small problem, which I am sure has a very simple solution. I need to have an sql database, which is server only, so it the client does not have create original rowset and therefore does have have access to any of the server data. The client data is persistent client only, and it needs to send the data to the sql database which has auto-increment setup. My problem is that I get errors about not mixing client only and server only page sources. Is there an example of a page that just has a single input that when a button is pushed it sends the data to the server and does not need to read it back again. I know this sounds really simple but I just cannot get the data to update on the server.

The trouble is that I do not want to have the original rowset enabled as I do not want to download any data from the server. As there is so much data it slows the app down comparing the data for changes. I just need to send the client data at the server. The bulk insert would do what I need but it does not allow me to select persistent data to put into the send array.

Sorry, I misunderstood. I will change the way the data is kept so that bulk insert works but is there an easy way on doing bulk insert with over 300 fields eg a script.

I have this working manually where I place the values into the insert into array eg. [90909,99,999,9999,99999,0]
but when I try this:-
[element Row {
for $i in $PERSISTENT/Root/test/*
return attribute { $i/name() } { $i/text() }
}]

or

element Row {
for $i in $PERSISTENT/Root/test/*
return attribute { $i/name() } { $i/text() }
}

It just puts spaces into the first value and null into the rest in the sql database. I just need tthe code to read through the persistent fields and send the values in an array. Any help would be much appreciated.

Thanks

The database is simply fields called a,b,c,d,e and they are all character fields. The app is 5 boxes in a persistent file with attributes a,b,c,d,e and a button to submit.
I need to make the attributes in the app bulk send to the sql server, so if the app entries were 1,2,3,4,5 then it would send [1,2,3,4,5] to the sql database.
I am having problems getting the correct syntax so the attributes are sent to the sql database. Please can you supply the script for the values part of the bulk send procedure where it reads all attributes and creates an array to send to server.

Many thanks

In this case the statement is

$PERSISTENT/Root/test/array{@*}

I don't understand the question. You've asked me about a statement to create such array, I've sent you one.

Don't get confused with array{ @* } syntax
It will get you the arrays with rectangular brackets as requested