Below is my code for adding parameters in my vb .net code for prepared statements of npgsql. Dim xConn As NpgsqlConnection = ConnectDB() Dim xCmd As NpgsqlCommand = xConn.CreateCommand() xCmd.CommandText = "UPDATE " & xTable & " SET previous_tot_adj = @prev_adj ,tot_adj = @tot_adj WHERE version = " & _version & " AND monthly_mq_id = @Index" For Each Index In _Results.Keys If Not IsNothing(_Results.Item(Index)) Then xCmd.Parameters.AddWithValue("prev_adj", NpgsqlTypes.NpgsqlDbType.Double, _Results.Item(Index)) xCmd.Parameters.AddWithValue("tot_adj", NpgsqlTypes.NpgsqlDbType.Double, _Results.Item(Index)) xCmd.Parameters.AddWithValue("Index", NpgsqlTypes.NpgsqlDbType.Bigint, Index) End If Next xCmd.Prepare() xCmd.ExecuteNonQuery() After executing this code i get this kind of error . > A first chance exception of type 'Npgsql.NpgsqlException' occurred in …

Member Avatar
Member Avatar
+0 forum 2

*08:30:43,413 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-9) MSC000001: Failed to start service jboss.module.service."deployment.crss-webui.war".main: org.jboss.msc.service.StartException in service jboss.module.service."deployment.crss-webui.war".main: JBAS018759: Failed to load module: deployment.crss-webui.war:main at org.jboss.as.server.moduleservice.ModuleLoadService.start(ModuleLoadService.java:92) [jboss-as-server-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8] at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0_67] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0_67] at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_67]* **Above is a part of my full stack trace** can anyone help me distinguish the error, i cant tell what is causing me this error.Thank you in advance. This is a maven project using hibernate, Jsf.

Member Avatar
+0 forum 0

Can anyone show on how can i move an image on an excel sheet to a specific cell. Thank you in advance.

Member Avatar
Member Avatar
+0 forum 7

I always feel sleepy at work . During afternoon..

Member Avatar
Member Avatar
+1 forum 32

NARUTO .. :P

Member Avatar
Member Avatar
+0 forum 4

Can anyone help me. I have this excel data that i want to transfer to a ms word. Or can i convert an excel file to word? Thank you!

Member Avatar
+0 forum 0

Does anyone here can show me a sample query on ms access database?

Member Avatar
+0 forum 0

hehehe .. :P .. mine is jessica

Member Avatar
Member Avatar
+2 forum 17

i have this code an everytime i run it. `ActivePrinter = "PDF Complete on PDFC"` `ActiveWorkbook.PrintOut copies:=1, collate:=True, Preview:=False, PrintToFile:=True,` `PrToFileName:="C:\Users\srnardo\Desktop\CONVERT" & "\" & strFileName` i get this : >Runtime error '1004': >Your file could not be printed due to an error on PDF Complete on PDFC. im trying to convert excel to pdf using macros..

Member Avatar
Member Avatar
+1 forum 1

Can i convert an excel file to PDF file .. can anyone give me an example macro .. Thank you guyss ..

Member Avatar
Member Avatar
+1 forum 5

I have this code. pdfCreator.ActiveSheet.PrintOut copies:=1, ActivePrinter:= _ "PDF Complete on PDFC", collate:=True How can i add a save location to this code . My default is the desktop when i save all the the file to be converted my desktop becomes a mess . can anyone help me how can i save it to a specific location. thank you!!

Member Avatar
Member Avatar
+1 forum 4

DOes anybody here know how to use send key for alt+s . can you please tell me how to do it. thank you!!

Member Avatar
Member Avatar
+0 forum 6

The default print area is upto cell H how can i extend it to I? Can anyone here help me .. thank you.

Member Avatar
+1 forum 0

Can anyone tell me how can i convert excel to word . I hope anyone can show me how to include the tables in the convertion. thank you!!

Member Avatar
Member Avatar
+1 forum 2

hahaha .. :P .. lets see who is the best here.

Member Avatar
Member Avatar
+1 forum 2

“Are you religious? [Why?] Because you’re the answer to my prayers.”

Member Avatar
Member Avatar
+1 forum 27

Hello, Everyone I'm proud to be a DANIWEBIAN now .

Member Avatar
Member Avatar
+3 forum 11

To see my sister eat my PAN CAKES. :(

Member Avatar
Member Avatar
+1 forum 23

Do anyone here Know how to get the previous month of a given date.. Example given date: 11/25/2012 Output: 10/25/2012 thank you.. i know you can help me ..

Member Avatar
Member Avatar
+1 forum 3

What Do you think about Bootstrap?

Member Avatar
+1 forum 0

Can Anyone here can tell me How to create a Date Picker in MS EXCEL using MACRO. And Binding it with a Button onClick Event. Thank You

Member Avatar
Member Avatar
+2 forum 5

I always get this error: >RUNTIME ERROR '32809' > Application-defined or Application-Defined error file_Path = interpo.ActiveSheet.Range("B12").Value number_of_loops = (interpo.ActiveSheet.Range("B9").Value - interpo.ActiveSheet.Range("B6").Value + 1) * 96 do anyone know how to fix this.

Member Avatar
Member Avatar
+1 forum 1

Hi, i have a form and i have 2 input box. Is there any way to restore the last input in reopening the Form. 'is there any code like this? userform1.input_date.value = userform1.input_date.lastValue Thank you in advance.

Member Avatar
Member Avatar
+0 forum 2

CAn anyone help me how to create a file browser using excel macro? Thank you guyss.

Member Avatar
Member Avatar
+0 forum 2

Can i ask, if how can i avoid too much time in debugging? How can i make my debugging faster? what is the best practice?

Member Avatar
Member Avatar
+2 forum 4

Can Anyone Show me how to make a user form to be risize able. I'm using excel macro, but i can't find in some way to do it. is there anyone here who can show me how. Thanks a lot .

Member Avatar
Member Avatar
+2 forum 1

The End.