[database] Forum Topics

How do you access a database from a C++ or Windows API program? :-/ I would like to be able to get data from a database as strings or something. I want to use a database so that it is easily changed from MS Access or something similar. Thanks in …

Hi, i have tried to insert all rows at one time from datagridview c# into a table in database , although the table gets all the rows from datagridview but it always gets the values of the last row from datagridview for all the other rows , so all the …

Hey team, i'm having a problem with this query, [code] "SELECT * FROM marketingDB WHERE company_name LIKE 'allied' & '*'" [/code] the program ive written runs fine and it doesnt show any problem with the query infact the exact same query works fine on access but when i put it …

Im looking to Delete a row of information in my datagrid, but also from my database. im not even really sure where to start. I want to use a button to do this. so that when i highlight a row, then click the button it brings up a message box …

I have been making some changes to an application that uses an ASP.NET Membership services database for authentication. I can access the database locally using windows authentication, and using my SA user. However, after moving the application to the prod. server, I can't access the DB at all. I wrote …

Hi team, I'm having some issues getting the results of my query to output on a data grid. I'm using an sql query to get the data from access, which is working fine, but then I want to output it onto a datagrid. My code is as follows just for …

Hey guys, I know this is an odd post but I cannot seem to get a straight answer where ever I look! I know you can add stuff to spreadsheet via a form which is great, but I want to create a form that allows me to search through the …

I have been trying to connect Database in Java for a quit time now. Following is the code. I have worked with .mdb extension, but this time I am using .accdb extension. Database File. [icode] import java.sql.*; class DB{ static Connection con; static Statement sta; static void getDBConnection(String path) { …

Dear VB Pros, Please I want to solicit your assistance on a comprehensive database design for the following explanation: I have a customer order form comprising of: 1. the following controls will get information from the customer that will be stored in the customer table. [[B]CustomerName[/B]], [[B]CustomerAddress[/B]], [[B]City[/B]], [[B]State[/B]], [[B]DateofPurchase[/B]] …

at a current project I was ask to provide a native access using Visual Basic and the Btrieve API. Since there isnt any actual sample at the website availabel ([url]www.pervasive.com[/url]) I thought posting it might help some of you. You can find sample code but almost all of them using …

Hello, I am trying to insert an html document into a modal window based on the results of a database query using plone/tal and jquery. What I need is for the "href records/rpc*_url" to be a link to the html document of the same name as the query result. i.e. …

Basically I have a database and a form set up that enters information into the mysql database using php code. This works perfectly. The problem I'm having is writing a php sequence to send an email that confirms the user wanted to post the information. I would also like the …

Hi Guys I want to write a program that extracts links from a url and then adds them to a mysql database. I have found some nice examples ie [CODE=php]<? function getlinks($url) { $data=file_get_contents($url); preg_match_all('/(href|src)\=(\"|')[^\"'\>]+/i',$data,$media); unset($data); $data=preg_replace('/(href|src)(\"|'|\=\"|\=')(.*)/i',"$3",$media[0]); return $data; } //now to use the function echo "<xmp>"; var_dump(getlinks('http://www.google.com.au')); echo "</xmp>"; …

Hi All I am trying to create script which will update the database every 24 hours to reset a row back to 0. My web host cron job panel does not work so that is why i am asking you for help. I will be very grateful for any help. …

Hi All. I am currently designing a photo sharing website. I need to make a script that deletes the image from the folder it is stored in and also from the database. I have done the database bit but i cannot work out the deleting from the folder bit. Any …

please guys i need your help , i have got a database with the name of a2354076_db and i have created the table caller users with this code : [CODE] CREATE TABLE users ( P_Id int, username varchar(255), pass varchar(255), email varchar(255), country varchar(255) ) [/CODE] and then i wanted …

I have a client and a server - the client sends the server a message, and depending on what message is sent, the server will perform an action and then reply to the client. Most of the actions that I have implemented are working. I need help with one of …

Hi I am new to delphi and I am trying to add a new form to an existing MdiApp program which links to various SQL tables The existing buttons that move the user from one form to another have the OnClick event (CmdBeginTestingClick). This OnClick event automatically attatches the following …

So, a single user application, all data is local, no remote access .... If a go with an Access file (DB), from the user's perspective, they simply install the app and they are good to go. Is it the same if I go with a SQL DB, or do they …

Boas. Estou com uma dúvida para o qual preciso mesmo muito da vossa ajuda. Criei um report que inclui dados de 1 trabalhador (id, nome, residencia, bi, categoria profissional, etc...) e preciso de fazer o seguinte comando SQL: [B]SELECT * FROM Trabalhadores WHERE id_trabalhador = ' + valor + '[/B] …

The code from my answer to thread: [url]http://www.daniweb.com/forums/thread292949.html[/url] Any field names with any same separator separating the values. This is straight text file reading routine, see the original thread for csv module based code. sample.dat: [CODE]id; name; email; homeaddress 123; gishi; gishi@mymail.com; 456 happy st. 345; tony; tony.veijalainen@somewhere.com; Espoo Finland …

I call the getTitle function but it only returns the last DB value. I presume that is because there are many rows in the DB with the same 'code' However when I call the function I want to get all the values for TITLE where code is something in the …

How can i edit a text file on a server and how to receive it back in a text box.And at last how to check wether a particular word is there or not. If you can get any of this then please let me know at [URL="kvermamanas@gmail.com"]kvermamanas@gmail.com[/URL] You may tell …

Hello :D i'm new here .. I'm 15 years old and wanna learn for making online shopping website which including like make user database with mysql and make shopping cart . I already installed XAMPP on my comp . But i don't know how to make login form in my …

I am currently trying to create a live search box that as I type it will start displaying results that match. Here is an example [URL="http://www.w3schools.com/php/php_ajax_livesearch.asp?output=print"]http://www.w3schools.com/php/php_ajax_livesearch.asp?output=print[/URL] but it retrieves its data from an XML file, I need mine to retrieve from a column called FirstName within a table of an …

Hi, I'm trying to make a rather simple Visual Basic app with which I can update some tables within my MySQL databases. I've been following [URL="http://www.vbmysql.com/articles/vbnet-mysql-tutorials/the-vbnet-mysql-tutorial-part-3"]this tutorial[/URL] from page 3 on, as the first 2 pages where on how to initialize a local MySQL database. My MySQL database is on …

Hello Guys... I'm a novice in both php/mysql. I'm creating an application and have many problems with it.I need help with some of the areas. First my application is a multiple forms based. The first page is that an admin logs into it by authenticating with mysql (This part I've …

Hi, I would like to get help in designing a table for representing a range in a column. Lets say we have a excel sheet of a matrix like below. GameName | agegroup 20-24 | agegroup 25-29 ------------------------------------------ Cricket | ------5--------|-----7------ Football | ------3--------|-----9------ Lets say the numbers represent the …

hi friends I am developing a osCommerce website and I am strucking with displaying items. Ok Ill explain what my issue in my site ok I am using a sql query to display all the product in database. ok this is my query [CODE]$products_new_query_raw = "select * from " . …

Hello, I have looked over many examples of how to populate a dropdown with rows like [code=php] $sql="SELECT id, thing FROM table"; $result=sqlsrv_query($conn,$sql) or die("Couldn't execut query"); while ($data=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)){ $id=$row["id"]; $thing=$row["thing"]; $options.="<option value=\"$id\">".$thing "</option>"; } [/code] But i need to populate this list with tables and will need to …