Search DaniWeb - db2

Re: Database wrapper for Codeigniter 3 2 Weeks Ago by pyeri Glad to know that Daniweb uses CodeIgniter! It's a very minimal but robust framework and has all the bells and whistles which other so called "modern" frameworks keep talking about. I 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` … Re: Unpopular Opinion: Bootstrap+jquery+CI is the best thing since sliced bread 2 Weeks Ago by Dani I've posted my story many times before, but here it is again :) I've been programming the majority of my life, first in Apple BASIC, then QBasic, then Visual Basic, then C++. PHP was my first foray into web development, and DaniWeb was my first project. DaniWeb started 22 years ago with phpBB, and then evolved to vBulletin. I knew the phpBB code… Using Natural Language to Query SQL Databases with Python LangChain Module 2 Months Ago by usmanmalik57 The advent of large language models (LLM) has replaced complex scripts with natural language for automating various tasks. You can now use LLM to interact with your databases using natural language, which makes life easier for people who do not have sufficient SQL knowledge. In this article, you will learn how to retrieve information from SQL … Re: Improve HAVING BY performance 2 Months Ago by Biiim > I don't have experience with MariaDB, but in MySQL, something like that will work as long as I do SELECT sum(points) AS total FROM ... HAVING total > 10. Is that what you were getting at? Kind of, MariaDB is a fork of MySQL from around 2009 or something like that, MySQL 5.* and the creator continued developing MariaDB and Oracle took … Re: Improve HAVING BY performance 2 Months Ago by Dani > I know that in my experience, OR's are very bad for speed you can get away with a few but they can get very bad when they stop the whole query making use of one of the main indexes, you can actually speed it up by moving the or's into the HAVING usually. Thank you for that tip! I never thought of that, but it totally makes sense!! > … Re: Improve HAVING BY performance 2 Months Ago by Biiim > INSERT INTO electronics.products(ProductID, ProductName, Price) VALUES ('1','capacitors', 2.50), ('2','resistors', 4.50), ('3','rectifiers', 7.50), ('4','diodes', 10.00), ('5','ICs', 25.00), ... ('50000','...', ...); I don't see any mention of an index on it & your benchmark indicates you don't have one: ALTER TABLE `… Re: How to query database using variable and get all results not just one row 2 Months Ago by Biiim logically, it would be because `WHERE variable_name = :variable_name` matches 1 row in your table maybe 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 DB directly I don't use PDO so i'm not too familiar on how it returns results, either … Re: Using Natural Language to Query SQL Databases with Python LangChain Module 1 Month Ago by aishamushtaq very helpful Re: DB.php Problem 16 Years Ago by richie513 You now need to install the DB Package for PEAR and point the files that are calling on the DB.php file to point to that folders direction. P.S There is no need to change the php.ini file inside of the bin folder of apache. Just the one in the PHP directory:) You will have to download the DB package and install it manually as it is not … DB Design, trying to keep in sync without foreign-keys 16 Years Ago by cancausecancer I'm designing a db for a project which has tables: mainAccount, id int(11) auto_inc primary key username, password, country, email, verification users, id int(11) auto_inc primary key `type` tinyint (3) -fk userType.id description nvarchar interests nvarchar website nvarchar (many other columns..) userIndex, … 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. That's over a year of data and along the way, I took that system and implemented to 4 locations and 4 individual servers. I've major software updates and Schema changes (adding Views, SP, changing Tables, etc.) By doing so, I can't keep up with all the changes and … Re: db run 14 Years Ago by network18 [QUOTE=itisnot_me;1094401]ok so what i want to beable to do is have a coded up website template (with php in it) that is stored in the DB. and i would like to call it in a query. That part works fine but what doesnt work is the php being called from the DB. It seems like it just calls the php but it does not execute. I did look this problem up on … DB-Authentication php/mysql on Mac OSX v3 19 Years Ago by jani Hello. I have installed PHP4 and MySQL (.dmg) on Mac OSX v3 client. Everything is up and running. I have created tables in my DB, established user privileges, etc through the 'terminal' app. I have turned on web sharing through the 'preferences' panel and dragged my .php files to the 'sites' folder. Accessing localhost/127.0.0.1 I see the .php … 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 Hello - I'm just looking for 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 company name history in the event of name change, buy out or merger such that there is a traceable account history. I've come up … db run 14 Years Ago by itisnot_me ok so what i want to beable to do is have a coded up website template (with php in it) that is stored in the DB. and i would like to call it in a query. That part works fine but what doesnt work is the php being called from the DB. It seems like it just calls the php but it does not execute. I did look this problem up on the oracle (google) but saw… db modeling 14 Years Ago by sasha_3 Hi everybody, I have made my ER diagram for my DB, but i want it optimized. The db should store date for something like in attached images. I thought about a Products table with attributes: some_primary_Key, product_id, component_id,... The number of component is stored in another table; the question is how do i structure this dates so … DB SQL creating da/ds 12 Years Ago by applebule5 I am trying to set up a database with Students, Courses and grades. This is the main bulk of my code, I am stuck with the error below, could anybody help me? [CODE] Imports System.Data.OleDb Imports ADODB Public Class Form_Main Dim cn As OleDbConnection Dim StudentUpdateCommand As New OleDbCommand Dim CourseUpdateCommand … 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 developed by another user who kindly helped me out, and I know for sure it was working. The difference being that after having some compatability issues when upgrading to a new version of VS, I decided to create a new project from scratch and basically … Re: DB issues when dropping DB and inserting test data 10 Years Ago by cgeier When clicking on "Drop Tables", you need the offer the user the opportunity to cancel, in case the user accidently clicked the button. **Issue:** The error "Error (Open Connection): Error in dataAdapter. Invalid object name 'Schedule'", is occuring during the table drop because the timer is still executing a query on the table… DB design for friends network 16 Years Ago by rwagner I am building a site for which I would like to add a "friends" invitation system. Once member invites another to be a friend, the second member has to accept to become friends. So both members have to agree to be friends. My problem is that I can't think of a db schema that will allow me to do this without being redundant or requiring… DB Design Issues 15 Years Ago by varun077 Hi Friends, Our project is developed in J2ee technology using EJB, now we are migrating to hibernate. We are using Oracle 10g. Architecture of this project has not been satisfactory (including database) and we have several performance and maintenance issues, we are changing the architecture and database design now. I have some questions about … Db structure needed please 15 Years Ago by jamescumm Hi, I am a technophobe in his last year of a business/computing degree. If someone gave me the db structure for my final year project interim report to be handed in tomorrow I will be forever grateful................ I am designing a website where people can search for spare car parts. It will basically display a bunch of listboxes until the … Re: DB Connection IN c# 14 Years Ago by mahmoud_wow 1-import the nameSpace [CODE]using System.Data.SqlClient[/CODE] 2- Make a new object from SqlConnection Class [CODE] SqlConnection conn = new SqlConnection();[/CODE] 3- set the ConnectionString property of the SqlConnection; [CODE]string connString = @"Data Source=[COLOR="Red"]ServerName[/COLOR];Initial Catalog=[COLOR="Red"… 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 Hi everyone I have a little problem I don't know how to fix. When I add data into the 'Preke' fields and click the submit button, it takes me to a blank page. It's suppose to take me to the 'Preke' page where the new info that's added, is displayed at the top of the page, with the rest of the old info underneath. I tried everything I know, but … 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]http://1[/url] 0 2 Reports Local [url]http://2[/url] 1 3 Reports Intl [url]http://3[/url] 1 Now I need to to display the label as Report - Local: So report will be linked to the … DB backup and restore problems 13 Years Ago by 00100110 Hello all, I 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 my code i get following error [CODE]IErrorInfo.GetDescription failed with E_FAIL(0x80004005)[/CODE] Anyone got an idea how to resolve this? Functions:…