Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Annie12345
- Order by date
-
compare a string in sql database
That would be indeed the easiest way, but it's a for-loop (lines out of a file) and not all strings have "", and some are empty. So i have strings like this: A12, "A12", "", and empty. I put this in the for loop and now i get that list ['A','2','3'] and empty lists for the empty strings (I have...- Annie12345
- Post #8
- Forum: Python
-
compare a string in sql database
Can you put lists to strings as well with %? I got strings like: "A23". I've got to have the " removed. I used list to get it removed so now i have ['A','2','3'], but I don't know how to get it back as A23.- Annie12345
- Post #6
- Forum: Python
-
compare a string in sql database
That works :) This works too: cursor.execute("select gene_stable_id, display_id from hsapiens_gene_est__gene__main where gene_stable_id = '" + ensemblid + "'") Tnx- Annie12345
- Post #4
- Forum: Python
-
compare a string in sql database
Hi, I have a script to search for strings in a file and look them up in a database, however sql won't accept my string (for example ENSG00000152822), how should I do it? import MySQLdb db = MySQLdb.connect(host = "ensembldb.sanger.ac.uk",user = "anonymous", passwd = "", db =...- Annie12345
- Thread
- Replies: 8
- Forum: Python
-
Calculating with date/time
It doesn't work yet. It says: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\webserver\apache\htdocs\proj7\compsystems\med\uren_viewer.php on line 78 This is (a part of) the code I have now: $query = "SELECT month(date) AS month...- Annie12345
- Post #3
- Forum: ANSI_SQL
-
Calculating with date/time
Hi, Can anyone help me to make a sql query (for a php website/administrating system) in which to calculate with date and time?? There is: Userid, Begintime, Endingtime and Date. I have to get the hours a month (how much the person has worked that month). So userid x has worked y hours in...- Annie12345
- Thread
- Replies: 3
- Forum: ANSI_SQL
