pavants |
Member |
|
Trieste |
|
|
None Specified |
|
Tuesday, June 4, 2019 |
Thursday, January 9, 2020 4:58:24 PM |
13 [0.07% of all post / 0.01 posts per day] |
|
Hi all, how can I filter the rows obtained from a query based on some parameters and produce java code ? actually is not supported, is there a workaround ?
Thanks
|
Is there a way to change the connection string name ?
I see that when the code is generated some objects take the name of the connection string of the database so name could be very long for example when database host is on cloud
|
Hi, I Have the same problem, did you figure out how to resolve the problem ?
|
Ok, Sorted out the problem on transforming from string to date but now when I try to insert the data in MSSQL database the code generated is:
INSERT INTO [Mytable] ([Rcvd_DateTime]) VALUES (2019-09-12T15:44:47.007+02:00)
Testing it in _Sql management studio I have an error on T15:, which is the best way to write this type of data in the db ?
|
found the problem, the column was declared as Date. Changed to String and parsed it as date.
|
Hello All, I have a csv file where a date is in this format: MM/DD/YYYY and I'm trying to insert it in a SQL Database to a column of datetime2 format. to do that I use parseDate passing as format [M,2]/[D,2]/[Y,4] but I get Type Mismatch The value '06/01/2019' is not of type 'date'
I tryed also with formatDate (which receive a string) but the problem is the same.
Any idea?
|
In FlowForce I think should be very useful to have in the configuration Job list a checkbox function to enable/disable the job without to enter in it and modify
Thanks.
|
my vote to have it.
|
I have a function that every 5 minutes polls a directory and if a file is present send files via as2. After the process I want to move the file in another directory but when I call the move function the result is everytime "Failed moving the file: Access is denied."
I guess is the loop that keep the file locked so how can I move the file ?
thanks forum
|
Hello Forum, I'm trying top manage the result of a AS2 send process, to acheive this I read the MDN returned by the partner and if successfull I want to move the file sent.
I created these steps: system/as2/send > store mdn in result
system/compute, exp: as2-success(mdn) -> result to as2success variable
system/compute exp: as2-mdn-serialize-> -> result in string
system/flesystem/copy -> save the stram to file
Expression Choose When: as2success true ->move file otherwise -> send mail
All the process run smooth, I receive and save the MDN, if I open it say message successfully sent to partner and partner received the message. But, the result of as2-success(mdn) is everytime false. In the first step send I used also Abort on error and it not fails so transmission is correct.
What I'm doing wrong ? Thanks
|
|