AGG Software Forums
November 24, 2024, 12:53:22 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
   Home   Help Search Login Register  

Pages: [1]
« previous next »
  Print  
Author Topic: TCP/IP Logger and SQL Pro plugin  (Read 14640 times)
microman3000
Jr. Member
**

Karma: +0/-0
Posts: 13


View Profile
« on: September 12, 2022, 02:00:00 PM »
I am trying to get SQL pro plugin to check the value of a field in a MYSQL table. If the value of the field matches then update the row with the new data. If the value in the field doesn't exist then create a new row.

Basically - IF EXISTS THEN UPDATE ELSE INSERT

I am tearing my hair out try to do this. Does anyone have a suggestion?

Thanks.
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #1 on: November 16, 2012, 08:18:11 AM »
You need to create a stored procedure in the database with necessary code and call it from the plugin.
Logged
microman3000
Jr. Member
**

Karma: +0/-0
Posts: 13


View Profile
« Reply #2 on: September 13, 2022, 02:00:00 PM »
Brilliant! Didn't think of that. Newbie duh!

Thanks very much
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines