2,569 Topics
 | |
 | I have the following code that works fine, it opens and excel file and uploads it into SQL. these excel files can have over 120 thousand records. I would like to put a progress bar on the upload so the end user knows how long the upload will take. The … |
| | I have a program that I wrote that creates a database in SQL Server called States_02 as a sysadmin user. Later on I want to grant SELECT permissions to that database to another user, web I always get an error that it cannot find States_02 or I don't have permissions …  |
| | Ok i have a lot of tables that are created when a user inputs information. Some info gets stored in a "Main" table while the majority is saved in its own self created table. I do not know the number of "topics" in Main table. so in way i'm trying …  |
| | i have four computers connected to broadband ADSL router MS SQL Server is installed in all computers while i have done steps given here [url]http://support.microsoft.com/kb/914277[/url] it had worked on local networking some time ago but now its not accessing remotely. i m confused its just because of broadband ADSL. if … |
| | Hello guys, [CODE] <?php include 'dbconnect.php'; echo 'under profile.php'; $username=$_SESSION['username']; //I think i have to put a query here like "SELECT username FROM accntinfos WHERE username='$username'". But confused since if I do there would be two queries $query="SELECT userprofile.profpic FROM userprofile INNER JOIN accntinfos ON accntinfos.accntnum=userprofile.accntnum"; $result=mysql_query($query, $DBconnect); $numrows=mysql_num_rows($result); ?> … |
| | Hi.... I am trying to connect sql server with vb.net in Visual Studio 2008 with foll. code.... but it is having problem....what is the problem? Please tell me.... 1. I created "publication" databse. In table i took 2 columns...fname and lname and fill the records... 2. I took DataGridView onto …  |
| | I have a database full of user. This is roughly how the database looks: [CODE]| username | sex | birthdate | zip_code | |----------+-----+------------+----------| | coolUser | M | 02-14-1987 | 90210 | | blueUser | F | 06-16-1982 | 10011 | | . | . | . | . …  |
| | I have a database full of user. This is roughly how the database looks: [CODE]| username | sex | birthdate | zip_code | |----------+-----+------------+----------| | coolUser | M | 02-14-1987 | 90210 | | blueUser | F | 06-16-1982 | 10011 | | . | . | . | . … |
| | Hi all.. I hope someone here can help me to solve my problem...I try to serach and get the solution from google..but it not help much... when I click button on page..the data will inserted twice in my database... i using select and insert statement in same connection... also have … |
| | I have created an online form and am trying to post the info into a mysql database and I keep getting back a query error. Below is my PHP code. If anybody can help me, that would be great. Thanks a lot. [CODE] <?php $property_type = $_POST['property_type']; $number_of_bedrooms = $_POST['#_of_bedrooms']; … |
| | hello, I have a situation that i'm wondering if there's a solution. I have specific databases for different cities in texas. I plan on adding more but i do not nkow how many more or what their names will be. Every city is going to have the same tables in … |
| | Hi! Im new to MySQL RDMBS. I know the basic CRUD if you know what i mean. Create Read Update Delete. I have 2 tables: Category table and Product Table Products should be categorized. Product table has PK as an ID and FK to Category Table How to INSERT INTO … |
| | Good day guys =) ..., i know there are somewhat similar threads of this around here but i still cant find the one to solve my problem ... well i am currently building an online store.. and in this online store there's a table of products with the an image, … |
| | Hello everybody, I want to transfer gridview cells values from one page to another. Here I used query string but to shock its working for some fields and for other fields(gridview cell values) its not working. The page which has gridview I used this syntax: Public ReadOnly Property email() As …  |
| | Give Me Reply to Develop Faster Loading Sites..:)  |
| | hi frnds , i have a combobox containing countries name and their codes like INDIA:CNT001 then i have a textbox that store the code of country i.e CNT001(fetching from database) Now i want to match that code with the combobox code so that the combobox is set to that item … |
 | Hi. I need to retrieve and list out the records from 'expenses' according to the date (eg. January 2011). I used substring to get the month (01 for January, 02 for February, etc.) and year. My date format is DD/MM/YYYY. I've tried echoing out $sql2 and the values obtained are … |
 | so i have a working ish program now, when i add the record it saves and returns the save message box as it should and is viewable in the database where it saves to, but it is not viewable in the text boxes when looking back at the form until … |
| | Hi all, I'm new to vb.net and Sql server... So it may be a newbie question, but i've searched many places and did't find the answer.. so, here i go: I've just installed sql server, and i want to databind some textboxes in a form... but i dont really know … |
| | Hi, I want to create a database like Dmoz(dmoz.org). I have a problem with creating parent child relation. I want to create parent child relation. This parent child relation will be assigned to a 'links' table. In the links table I will insert data whether in root category or subcategory …  |
| | I have been developed shareware software name [B]DBEXform[/B] to design forms and reports for different databases, with integrated Sql query builder. Basic functions in software are quite easy to use. Now it seems that potential larger users likes it, but they afraid to use is because lack of a local … |
| | Hello , i have two tables ,animal ,which has name,familie and weight and table food which has feed. I want to assure that every animal has at least one food. I did this : [CODE]import mysql.connector from database import login_info db=mysql.connector.Connect(**login_info) cursor=db.cursor() data=[('Geo','Elephant',['hay',peanuts']), ('Gerald','Gnu',['leaves','shoots']), ('Leo','Leopard',['meat']) ...................... ] for name,familie,feed in … |
| | [URL="https://docs.google.com/document/d/1bXZixHNn4gsjU4ZxmaMIhicewVApoJpEbE_Yb3SOAYI/edit#"]https://docs.google.com/document/d/1bXZixHNn4gsjU4ZxmaMIhicewVApoJpEbE_Yb3SOAYI/edit#[/URL]  |
| | SELECT * , 3956 *2 * ASIN( SQRT( POWER( SIN( ( 122.4058 - ABS( dest.lat ) ) * PI( ) /180 /2 ) , 2 ) + COS( 122.4058 * PI( ) /180 ) * COS( ABS( dest.lat ) * PI( ) /180 ) * POWER( SIN( ( 37.7907 - …  |
| | I have this query, but the ordering by is not working. It should order by value, but doesn't react. you'll see what I mean in the code. [ICODE]<table class="pme-main"> <tr> <th class="pme-header">Bestemming</th> <th class="pme-header">Naam Klant</th> <th class="pme-header">Aantal Manden</th> <th class="pme-header">Aantal Duiven</th> <th class="pme-header">Naam Bestemmeling</th> </tr> <?php $con = mysql_connect("****","****","****"); if … |
| | Iam developing a small school software. I want to show fees of every student of whole year. Like John(student) I want show his fees that every month he paid at what date and how much. So how should I start please help..  |
| | In going through some homework, I was able to do some of the problems, but not others. For example, one problem was "Produce a list of employee last name, first name, job function, department name and department location. Use appropriate, user friendly column aliases." I finished this with this code: … |
| | hi, this is relating to a wordpress site, i have this query [CODE]$qstring="SELECT * FROM rwb_bk_schedule s INNER JOIN rwb_bk_rooms r ON s.room_id = r.room_id WHERE s.room_status=1 AND r.room_name='".$room."' AND start_date BETWEEN '".$sdate."' AND '".$edate."' OR end_date BETWEEN '".$sdate."' AND '".$edate."'";[/CODE] as i given the code i use OR there … |
| | I am beginner and this is my [B]first project[/B] (happy face). I am trying to make log in systen to learn php and mySQL. At first everything was working so and then i decided to rewrite everything in [B]Object oriented[/B] code and then it is not working. Since it is … |
 | I just thought I would re-iterate something that I have mentioned a few times in my replies to threads on here in that if your code isn't working, one of the first things to do is actually test your query in the database (i.e. through phpMyAdmin). The reason I am …  |
| | dear all, [CODE]$member_id = $_POST['member_id']; $delete = 'yes'; $HOST = 'localhost'; $USERNAME = 'root'; $PASSWORD = ''; $DB = 'hrs'; $link = mysqli_connect($HOST, $USERNAME, $PASSWORD, $DB); $query = "UPDATE member SET delete='$delete' WHERE member_id='$member_id'"; echo $query; $result = mysqli_query($link, $query) or die(mysqli_error($link)); [/CODE] Any error in my query? it says … |
| | Hi everyone, I have made a script which logs the users ip into a table. Here is the table: [CODE] ID - PKEY A.INC IP - VARCHAR ENTERED - TIMESTAMP [/CODE] What I would like to happen is that after a row has been inserted, I want to set up … |
| | Hello, I am getting the contents on my website from database using SQL Stored Procedure (C#). Now, I want to change the output look with XML / XSLT. How can I do this? Something like this http://forums.asp.net/t/1230093.aspx/1 but am not sure how to go about it, am new to C# … |
| | Hey everyone! I am working on a project that involves querying a mysql database using php, and I am running into some issues. html form is in list_files.php and the query is in query.php .. i also attached my mySQL database which has 2 tables: only the file table is … |
| | Hi Everyone- We are building a database that needs table(purchaser) to check table(paypal) for a matching telephone number. Table(paypal) has 'purchaser telephone' as PK and table(purchaser) has 'purchaser telephone' as FK. I can insert and see the data in both tables, but running a select query returns an empty result. … |
| | dear all i have 2 tables, one is project table and another replies table. [ICODE]"SELECT * FROM project, replies WHERE replies.member_id=$_SESSION[member_id] AND project.project_id=replies.project_id ORDER BY project.project_id "; [/ICODE] the above code gives me all , but I need the latest updated replied in each project id I tried [CODE]SELECT * … |
| | Dear All, I got one table as the tblMasterData then I left join it with another table like this tblEventAlert. So what I want to do if there is a match between tblMasterData and tblEventAlert then for that tblEventAlert I would like to match it with tblDevice to to get … |
 | heres a form i have created. its a search form. [url]http://img266.imageshack.us/img266/722/paymentsh.jpg[/url] it searches and lists the results in list view. heres my mssql query : [CODE] select transactions.trans_id,transactions.cust_id,transactions.trans_amount," _ & "transactions.trans_date,customers.fname+' '+ customers.lname as customer from transactions inner join customers on transactions.cust_id=customers.cust_id " _ & "where trans_type='inv' and (trans_id= " … |
| | I am making an invoice system. Please have a look at the images. [url]http://img32.imageshack.us/img32/9216/capture1iv.jpg[/url] [url]http://img839.imageshack.us/img839/1228/capture2cq.jpg[/url] as you can see, the place order button is creating an invoice. I have actually created a junk table and a junk column in it just to setup the invoice_id and load it when "invoice … |
| | I am making a DBMS using C#.Net and MS SQL. i want to display the data using crystal reports. In the Database Fields when the Database Expert wizard opens after choosing OLE DB (ADO) and then OLE DB for SQL provider, i have to give the Server, user & password … |
| | This is homework. I have to create two tables with certain constraints. However, I keep getting syntax errors, and I really have no clue exactly how to format it because there are so many different 'templates' out there. Here is what I have so far. [CODE] create table Departments (Department_ID … |
| | I've my data in a Database. Using SQL,I need to print it on a list For example, My Table is: Teachers, and it has ID, Name and Phone#. I need a button which shows all this data in a list. My first thought is with a DataGridView.. ID Name Phone … |
| | Hi all, Anyone know how to create a dynamic gridview with the following specs: 1. Fixed datasouce (sqldatasource) with a fixed string connection (and database name) 2. Fixed select statement: "SELECT * FROM " + <table name> 3. <table name> came from textbox input and there is a button available … |
| | need to check an SQL Server database (not asp.net membership) to see if an email is already in use before allowing the user to register. I have tried using the information in this website but it does not seem to work. Your help will be much appreciated  |
| | I created a stored procedure as below: [CODE] DELIMITER$$ CREATE PROCEDURE updateCorporateDetails(IN companyName VARCHAR(30), IN rocNo VARCHAR(20), IN address VARCHAR(30), IN postalCode INT, IN state VARCHAR(20), IN country VARCHAR(20), IN contactNo VARCHAR(20), IN email VARCHAR(20), IN fax VARCHAR(20), IN lastUpdate DATETIME, OUT total INT) BEGIN DECLARE var1 INT; SET @var1 … |
| | Alright, let me start by saying that I know zero PHP or SQL code, myself. I have a SQL guy creating tables, and I've been using what I've found on W3C Schools. So far it's been ok, but I have a problem I need solved. I have created an HTML … |
| | Hi everyone, we have constructed a content management system that gets updated quite frequently and is used by many clients for their day to day opperations for their websites. We have decided to build a section of the CMS with additional modules that we will host on our cloud and …  |
| | Hello, I am having trouble inserting data from a XML file into a table in a SQL data base. The worst thing is it isn't coming up with an error but nothing is being inserted into the database Here is the condensed version of the XML code I am using … |
| | I'm trying to store a data from the checkbox. when i checked on NSO Birth Certificate it has to be stored into my mssql server. here is my code If nso.Checked = True Then strsql = "insert into student info(Requirements) values ('" & nso.Checked & "')" Dim sqlcmd As New …  |
| | Hey guys, only new to Daniweb, so pardon me, if i seem too "nooby" for you guys. I am building a website, and currently am working on the "members area" i have a database named "users" with fields "name", "username", "email", and "password". i am running a php script, and … |
The End.