Search the Community
Showing results for tags 'sql'.
-
UPDATE wp_24e1505507_gf_entry_meta SET meta_value = #myawesomevariable WHERE entry_id = 28 AND meta_key = 5; I can connect to database and select anything with no issues. The update statement works if I hard code a value. I know the above line is not correct for sql. How would I go about passing the ubot variable into a sql statement? Thanks in advanced Ubotters! Jason
-
I have scraped an html table with as many as 100 rows with 5 columns. Practically everything I have been trying treats the entire table as one variable. For instance, I'm able to write the table to a file. What I want to be able to do is loop through each row, one by one and explode out the row to 5 variables: cell1, cell2, cell3, cell4, cell5. I then want to use these (while still remaining in the loop for this row) in a SQL query: INSERT INTO db_table (col1, col2, col3, col4, col5) VALUES ('cell1', 'cell2', 'cell3', 'cell4', 'cell5') Seems very simple but I can't quite make this happen
-
Dear programmer, I'm looking for a way to connect to a Oracle database. Jason advised me that this might be quickly done by creating an own plugin like explained in the ubot wiki section: http://wiki.ubotstudio.com/wiki/Plugin_Development Most likely someone else had faced the same problem and solved it the same way or somehow else. Maybe it can be a Java Script or a Python script can be integrated - what can be supported by Ubot.I don't know? However, at the end of the day I should be able to enter the database details like host, user id, password etc.and be able to use the known SQL
-
Database connection works fine. INSERT, UPDATE, and SELECT work. How do you take a ubot variable and plug it into the UPDATE command? I checked the wiki and there is no example of this.
-
Closed I refuse to partner with someone like Cee's from Skype.. Wants to bash Americans whenever he gets a chance.. I wont help support anything of his.