Search DaniWeb - db

Re: How to query database using variable and get all results not just one row 4 Weeks Ago by Biiim … the sql on whichever way you use to access your DB directly I don't use PDO so i'm not… Re: Using Natural Language to Query SQL Databases with Python LangChain Module 2 Weeks Ago by aishamushtaq very helpful Using Natural Language to Query SQL Databases with Python LangChain Module 1 Month Ago by usmanmalik57 … the agent. ``` def get_db_response(db, query): agent_executor = create_sql_agent(LLM, db=db, agent_type="openai-tools",…. ``` sqlite3_uri = "sqlite:///D:/Datasets/Northwind.db" sqlite3_uri = SQLDatabase.from_uri(sqlite3_uri) query = … Re: Improve HAVING BY performance 1 Month Ago by Biiim … currently am looking at storing all data in a Redis DB updated periodically from MariaDB, so the backend updates the data… Re: Improve HAVING BY performance 1 Month Ago by Dani … currently am looking at storing all data in a Redis DB updated periodically from MariaDB, so the backend updates the data… Re: Improve HAVING BY performance 1 Month Ago by Biiim … it faster. I was using that for an email marketing DB ages ago (logging each sent email, failed, read, clicked etc… Re: Postfix authentication problem 1 Month Ago by chickenbirds > I am trying to set-up Postfix on my Ubuntu local web development machine for send-only e-mails using Gmail so I can test e-mails sent by a web app I am developing. Even though this is an old post I wanted to reply as I found it while trying to setup my own postfix mailrelay on my private cloud server with Debian that hosts our small … DB Design, trying to keep in sync without foreign-keys 16 Years Ago by cancausecancer …keys could help things and make updates/deletes/db consistency easier. Because innodb lacks fulltext search support…have to be dropped period because as the db grows it'll need to be to …I can get away with fkeys because the db is small but since I need to design …sure but watching for and trying to keep db consistency in the code is making me worry.… Re: DB.php Problem 16 Years Ago by richie513 … the PHP directory:) You will have to download the DB package and install it manually as it is not reccommended… here [URL="http://pear.php.net/package/DB/download"]PEAR DB Package[/URL] You will need a program that…extracted these files, browse through them until you see the DB.php and three Other directorys. One of those Directorys … DB Schema Export/Import Help 18 Years Ago by extofer I've been working on a production DB on a POS and Inventory System for over a year. … and take the software from the main location with the DB changes and run that same software in the other locations…??? Is it possible to take just the scheme of the DB and import it to an existing… Re: db run 14 Years Ago by network18 … php in it) that is stored in the DB. and i would like to call it in a…doesnt work is the php being called from the DB. It seems like it just calls the php…something else by just uploading the code to the DB. Unless there is better way. thanks in advance[/…QUOTE] If the HTML is stored in DB, you don't have any other option except taking… DB-Authentication php/mysql on Mac OSX v3 19 Years Ago by jani … is up and running. I have created tables in my DB, established user privileges, etc through the 'terminal' app. I …files - simple scipts work. The problem is connecting to my DB and being able to execute a simple query on any… entries. Unfortunately I cannot even establish a connection to my DB, the $PHP_AUTH_USER AND _PW don't seem to do anything… Re: DB.php Problem 16 Years Ago by richie513 Is this your own DB.php file, or are you trying to use the DB PEAR extension? If it is the PEAR DB file, you need to install PEAR then download and install the DB package, but in saying that, the DB package for PEAR is now out dated and is reccommended to you use the MDB2 PEAR package. Just some available info for you:) DB design capturing mergers and acquisitions 14 Years Ago by NewJoizey … some feedback and some discussion from other DB pros about the viability of a DB design I came up with. The goal… is to create the DB back end to an application feature that keeps track of… db run 14 Years Ago by itisnot_me … template (with php in it) that is stored in the DB. and i would like to call it in a query… what doesnt work is the php being called from the DB. It seems like it just calls the php but it… to something else by just uploading the code to the DB. Unless there is better way. thanks in advance db modeling 14 Years Ago by sasha_3 … have made my ER diagram for my DB, but i want it optimized. The db should store date for something like in… of a product_id; maybe a can reduce this with some db structure concept, 'cause i could have same component in more… DB SQL creating da/ds 12 Years Ago by applebule5 …quot;) Try DataBaseCreator() Catch ex As Exception MessageBox.Show("DB Allrdy there") End Try MessageBox.Show("DONE"…;) 'Define student DA and fill the DS with DB info DA = New OleDbDataAdapter DS = New DataSet cmd = New… Re: db run 14 Years Ago by itisnot_me understand but what about running php from the DB. in my template i also have php to call the navigation and info from the DB on top of html. Re: db run 14 Years Ago by network18 [QUOTE=itisnot_me;1094884]understand but what about running php from the DB. in my template i also have php to call the navigation and info from the DB on top of html.[/QUOTE] you need to do the same for it DB issues when dropping DB and inserting test data 10 Years Ago by pezza Hi All, Having a few issues with some DB functions in my code at the moment. This code was … having previously, it seemed to introduce some issues on the DB side. As far as I can see (and my eyes… Re: DB issues when dropping DB and inserting test data 10 Years Ago by cgeier …) Dim sqlText As String = String.Empty 'switch to 'master' db and 'put db into single user mode to prevent connections, then drop… DB design for friends network 16 Years Ago by rwagner …. My problem is that I can't think of a db schema that will allow me to do this without being… decent programmer and a good UI designer, but a novice db designer at best. I could use some recommendations. Thanks. DB Design Issues 15 Years Ago by varun077 … FK constraints are not there. Should we enforce FKs on DB level? There are some concerns about adding FKs like - performance… referential integrity to not to have any orphan records in DB. One alternative is to write triggers which will enforce data… Db structure needed please 15 Years Ago by jamescumm … of a business/computing degree. If someone gave me the db structure for my final year project interim report to be… it is available. If someone could give me a rough db structure for this I would be very happy. p.s… Re: DB Connection IN c# 14 Years Ago by mahmoud_wow ….Open() [/CODE] and after you finish your work with the DB close the Connection [CODE]conn.Close()[/CODE] Or you Can… , choose Server Name, if the any userName or Password for DB set it , Choose DB Name , press Ok. Re: db run 14 Years Ago by itisnot_me ya i was thinking that is what i would have to do. even though it would be awesome if you can run some php from the DB but with some good security features Re: DB access error 14 Years Ago by boet … $_POST ['description'] . "'"; mysql_query ( $query ) or die ( "DB access error (" . mysql_error () . ")" ); header( "Location: index… $_POST ['id'] . "'"; mysql_query ( $query ) or die ( "DB access error (" . mysql_error () . ")" ); header( "Location: … DB Url databinding to Labels 13 Years Ago by wrathyimp I have a pages table with following columns: DB Table: sno name title url parentPage 1 Reports Reports [url]… define the sql command to get the url from the db table. these are my code: cs: [CODE] public String pid… DB backup and restore problems 13 Years Ago by 00100110 … started a new project wich function is restoring a corrupted DB. I started with making a backup of the original… db and then trying to restore it again. But when executing … DB design for learning english words 13 Years Ago by jayanandan I am designing my own site to learn English words. Attached is the image of my DB design. Can some one suggest/direct me to design the DB more perfectly?