Search DaniWeb - sql-database

Re: Database wrapper for Codeigniter 3 2 Weeks Ago by pyeri … myself use CI3 for most of my freelance projects. For database interaction, I usually don't use the CI models, I… prefer dealing with the `$this->db` object directly with SQL queries. I use a couple of helper functions which make… Using Natural Language to Query SQL Databases with Python LangChain Module 2 Months Ago by usmanmalik57 … function, we create a LangChain SQL agent using the `create_sql_agent()` function. You pass the LLM and database to the agent. In addition…(query) return response ``` ## Generating Response from PostgreSQL Database Generating a response from the LangChain SQL agent is straightforward. First, you must create… Re: How to query database using variable and get all results not just one row 2 Months Ago by Mikekelvin …the current user // Query database to retrieve records associated with the current user $sql = "SELECT *…variable_name = :variable_name"; $stmt = $conn->prepare($sql); $stmt->bindParam(':variable_name', $currentUser, PDO::PARAM_STR); $… uniquely identify the current user in your database. By binding this value to the :… Re: How to query database using variable and get all results not just one row 2 Months Ago by Chris_103 …your code: ```php // Query database to retrieve records associated with the user $sql = "SELECT * FROM … variable_name = :variable_name"; $stmt = $conn->prepare($sql); $stmt->bindParam(':variable_name', $variable_name, PDO::PARAM_STR); $stmt… that match the criteria specified in the SQL query and store them in the `$records… Re: How to query database using variable and get all results not just one row 2 Months Ago by Biiim … try a `var_dump(str_replace(':variable_name',"'some_value'",$sql));var_dump($records);`? run the sql on whichever way you use to access your… Re: Using Natural Language to Query SQL Databases with Python LangChain Module 1 Month Ago by aishamushtaq very helpful Re: Improve HAVING BY performance 2 Months Ago by toneewa …. I setup a server, a database, and wrote a C++ program … Connector/C++ version 8 sql::mysql::MySQL_Driver* driver; sql::Connection* con; sql::Statement* stmt; int ct… WHERE here "GROUP BY ProductName"); sql::ResultSet* result1 = stmt->getResultSet(); while … sql database 7 Years Ago by davy_yg Hello, I almost forget. Last time someone recommend me a software that I could use repeatedly for sql database management that real web developer must have in exchange of the free one like xampp that often shows error. Can anyone help me fix this error? Thanks in advance, Davy sql database 13 Years Ago by swathys …how do i get latest transaction from sql database. All the records is saved in sql database and i use different application to grab… the data from sql base on transaction. I…i create unique variable to define different transaction in sql select statement. Please guide me !!! SQL Database 14 Years Ago by christian73 If I build an application using BS 2008 in C# that uses an SQL database, Do I have to include SQL Express as part of the deployment package? In other words, does the user need SQL Express on his/her machine in order to use my application if my app does all the work? SQL Database column wise Filtering 7 Years Ago by Faisal_13 … problem. Right now I am creating a Workers Directory with sql database. This is including worker name, Location, Work and mobile numbers… SQL Database Access 12 Years Ago by SimpleMan78 …set to windows authentication. I don't want to use SQL authentication because when the user changes their password from Windows…currently logged in user does not have access to the sql database? My guess is the AD verification will pass but when… it tries to create a connection to the SQL server it will fail because the logged in windows … sql database viewer 15 Years Ago by tuckeratlarge Didn't know where to put this, sorry Do any of you loverly people know of a proggy that will allow me to view an SQL database file ( .sql ) Its a wordpress database and I would like to extract the posts and comments. I have searched on the google and all I can find is gibberish I need a simple app for a simple boy. Any thoughts? SQL Database connection via network 14 Years Ago by WillemP Hallo i'm Rinning an application with a sql database on pc1 it works fine but if i install the application on another pc i can't connect to the database i'm using SQL Server Management Studio Express 2 setup the connection but i cant find the 2nd pc where the data is stored can someone pls advise me ty in advance WillemP SQL database to vb.net 12 Years Ago by bernardz26 Good day!. I have here a SQL database named Database1 and it has a tables (StudentID, Student name, Age, Gender,) vb.net and i want that if i input a records in vb.net it automatic save to sql database. Help me please. Re: SQL Database Problem 15 Years Ago by dlayante … wrong with my codes...It already have SQL Database connection and I successfully display my record from …the database.... Please help me...here's so far … EventArgs e) { string connectionString ="server=sroque\\sqlexpress;database=InventoryDB;uid=sa;pwd=ripple"; SqlConnection mySqlConnection = new… SQL Database for a Technical support centre 10 Years Ago by mcoliver88 Hi Guys I need to create an SQL database for my work, and use visual c# to build the … shop that is run by the students. They need a database created, but I am unsure where to start with the… SQL Database Problem 15 Years Ago by dlayante I have already connect my SQL database in C# windows application, Now, can somebody please give me sample codes for data manipulation, add/edit/delete of records....THANK you! SQL database stores data twice 14 Years Ago by chrispaul8676 hi there, i am coming up with a form. i have to insert data into the sql database. i am able to do that. The problem is that, when i insert, the data i entered one shows twice in the table. i just click once and there are the same data showing twice. I encountered this after including the dropdownlist. please help me. i am short of time. SQL Database language 11 Years Ago by ANSAYLOR Hello! I am working on an SQL Database project and I am supposed to find the names of … sql database autonumber combine with specify string 10 Years Ago by gahhon In the sql database definition i am able to set my primary key to int data type and auto increment that number (identity specification), thus the result will be in `1, 2, 3,....` but how can i add some string into it? example `C0001, C0002, C0003, etc` ? Re: sql database 2008 8 Years Ago by havoccultist … powerful resources http://smallbusiness.chron.com/restore-sql-database-mdf-file-46104.html https://social.technet.microsoft…-US/cc4cfcf8-93ad-4d8e-98db-9f241543da89/my-database-mdf-file-got-corrupted?forum=ssdsgetstarted https://…SQL Server's administrator user name is "sa." This account is required for privileges to restore the database… vb.net and website database connection(connected with same sql database) 11 Years Ago by nok.nee21 I'm planning to develop a system that can connect through online sql database and a website connected on the same sql database.. Can anyone help me.. Please response.. ms sql database string 10 Years Ago by adem87 Hello ım writing a program that it will work with sql database. i loaded a database which name is b.sql. but i need to connection string abouth user name , pasword and where is the location of database. How to Connect to online MS SQL database 13 Years Ago by IntegrityWebDev … I want to be able to connect to our MS SQL database and pull out info...but I dont want to just… me beginners pointers on how to connect to our MS SQL database in this manner? Thanks! Chris Login that retrieves hashed password from SQL database 12 Years Ago by megansims07 … and password will be verified on an SQL database of user information. I keep getting the error… "SQL Execution was unhandled" I marked the …myerror As SqlClient.SqlException MessageBox.Show("Error Connecting to Database: " & myerror.Message) End Try Dim … Re: vb.net and website database connection(connected with same sql database) 11 Years Ago by nok.nee21 can you give me some codes or advice or anything about connecting vb.net app and a website to a single sql database.. is that possible sir?? thank you if you can help me.. Using Local SQL database 8 Years Ago by Suzie999 My project uses local sql database. I tried the app on a non development machine for first time. Got a message saying it was downloading required files, sql 2008 express, at a whopping 600MB+ file. Please tell me I've done something wrong, and any user of my app will not have to download this. Re: How to add SQL Database to my project 12 Years Ago by androidz sql server 2005 could it be?if not what sql database should be use? Incorporating a SQL Database into your Android Application 12 Years Ago by BlackStar0703 …managed to create a dialog box ok but incorporating the sql database full of questions and answers is proving difficult. I've…the overall picture is a randomly generated question from a SQL database to appear in a dialog and once the user … what the answer is, which is also in the SQL database. Anyone know how I would obtain information from the…