How to assign the value of an Excel column in an SQL statement

Navigation
0

I was able to connect to my MySQL Database via ODBC, and display the information I need via SQL command, but I would like the contents of a particular cell in my worksheet to be in that SQL query, I get this:

Showonlythenameoftheclientaccordingtotheso-called"1016762", what I would like was for the sql command to look something like this: 

SELECT customer_id FROM 'otrs'.'ticket' where 'tn' = A7

    
asked by anonymous 10.04.2017 / 17:03

1 answer

0

I was able to release the Parameter button in Connection Properties by changing my SQL command to this: 

SELECT customer_id FROM 'otrs'.'ticket' where (tn = ?)

So when you try to execute the command a window is opened to request the parameter that will be used in Query

I found this tip in forum

    
11.04.2017 / 15:04
Put a delay on "this.form.submit ()"? Execute submit after auto complete field