openmolecules.org

 
Home » DataWarrior » Cheminformatics » Link to oracle per row
Link to oracle per row [message #1850] Fri, 17 February 2023 17:28 Go to previous message
de_maas is currently offline  de_maas
Messages: 2
Registered: February 2023
Junior Member
Hi All,

I want to retrieve data from my oracle database using an id stored in my Datawarrior file. Is it possible to pass a identifier to the SQL somehow? I tried this but it isn't working:

SELECT AVAILABILITY
FROM availability_info
WHERE description=$idnumber

I can't find the right synthax to do this. Same goes for the URL.

Thanks,

Peter
 
Read Message
Read Message
Read Message
Previous Topic: Generate 2D atom coordinates gives overlapping atoms
Next Topic: Searching multiple structures in Google patents via "selected compounds"
Goto Forum:
  


Current Time: Thu Oct 31 23:54:12 CET 2024

Total time taken to generate the page: 0.04272 seconds