6,934 Topics
 | |
| | Good morning, Firstly, let me say that I have zero experience with database, servers, etc. Now that I have prefaced this long question with that tidbit let me ask the most basic questions. What is the difference between MySQL and MS SQL? I think they do the same thing but …  |
| | |
| | I have a stored procedure. This proc returns some data that needs to be put in an excel format. Is it possible to create a excel file to have the result of a select statement from the database? please help me out. Thanks  |
| | Hi! I'm start learn php and i have few problems what i can't fix it. Before i say what is my problem, YES i have search for my problem in google and other. So my question is how to make 1)table with few data column and after few column i … |
| | NEED HELP~! Does anyone know how to import exel data into sql server using vb.net? I want to create a openfiledialog and allow user to choose which exel file to be imported into the server. Thank you so much~~ >.< PS. I am just a beginner of vb.net. So would … |
| | Hello all! So in my app, I have 5 columns, firstname,lastname,membership,accountid, and date. Once a members card has been scanned, the app figures out if that member is in my sql table or not. If he/she is, it will update their 'date' column in my dgv. If he/she is not, …  |
| | Hye, I had a difficulties to insert the data in vb.net into sql, I had try few times, but it seems the data can't be read in the database, I hope anyone could help me :( |
| | Hello, I'm using MySQL for a database containing 1 table with 10 columns. The point is to get a view of a few columns and use it in a web application So, I need 2 columns from this table - Pad(varchar) and Sequence(integer), then I create 8 views like this: … |
| | hi. i'm doing a search option in my system where if your searching for a entry even if you didnt typed the whole word, all of the entry that contains the letters that you have typed will appear, well i really cant explain it but it goes like this if … |
| | Hello I'm new to sql (sql 2000 database) and i'm trying to get two simple things. I have two sql queries that i run in order to display a result and to update another one. The queries that i run in sql query analizer are: 1. select memb_guid from MEMB_INFO …  |
| | [CODE]<form action= '1stform.php' method = "POST"> <fieldset border = "5"> <table> <tr> <td>Check Availability</td> </tr> <tr><td> <p>Garden Room: </label> <select name="room_GR"> <option value="0">0</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option … |
| | I need to update the SQL table every minute, as if typing on an online notepad, that save frequently. So of course, I have: [CODE]<textarea rows="20" cols="80" id="notepad"> <?php $con=mysql_connect("localhost","username","password"); if(!$con) { die('Could not connect: '.mysql_error()); } mysql_select_db("database", $con); $result = mysql_query("SELECT * FROM Notepad"); while($row = mysql_fetch_array($result)) { echo …  |
| | Basically, I make a query based on the first query that I made. It returns the right number of rows but it only displays the first record based on the number of rows. For example, if my second query returns Result1 and Result2, the table will look like Result1 Result1 … |
| | Hi i just want to know that how to connect php with sql server..because i have database in my sql server.... regards.. Farhad |
| | Hello all, I used to be relatively well versed in .Net back when 2.0 was still the latest framework and I have stayed out of the loop for a few years. Looking to kick in a new pet project, I am interested in developing in Visual C# / SQL again. … |
| | I'm trying to save data from textboxes in visual studio using vb.net to sql server 2008. the coonectiong is working perfectly but is not displaying the data output in data grid. This is the part of the code. [CODE] Imports Microsoft.VisualBasic Imports System.Collections.Generic Imports System.Data Imports System.Data.SqlClient Imports System.Text Dim … |
| | i have a query is to lookup CREDIT_CARD table using CREDIT_CARD_ID and get the MIN_REPAY_AMT. if SUM(AMOUNT_DEPOSITED) < MIN_REPAY_AMT for that month Then populate 1000 else 0 i have attempted the query below kindly help me out and i am getting the following error. Error: [CODE]ERROR at line 2: ORA-00923: … |
| | hello i have 5 text boxes and labels and database in sql server so just need coding for the next and the previous button any one can help please thanks |
| | Hi am really new with php mysql, i need help pls. I have created a email software in my server, there is a field for inserting email data info. Right now i am inserting these data one by one, but this is annoying and taking hard time. Pls help me … |
| | hi guys, i'm having an SQL Error in my CMS, somebody please have a look i get this error: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files (x86)\VertrigoServ\www\portal\estrutura\publicidades\exibe.php on line 73" my code: <? $variables=(strtolower($_SERVER['REQUEST_METHOD'])== 'GET') ? $_GET : $_POST; foreach ($variables as $k=> … |
| | Hi all i have a new problem that needs some solvin I'm trying to add data sets to Google's Javascript Motionchart from my SQL database via PHP Here is what i have so far: [CODE] <?php include "conn.php"; // Select all the rows in the markers table $query = "SELECT … |
| | Dear all, I have created a webpage and a SQL database runs in the background. When user enters options in the query page of my webpage, they get some tables with results. I want to provide an option to the user to download the results in tab-separated, tabular (excel) and …  |
| | Hello I'm doing a mini project of student management system. i need to take the attendance of all the students and store it in sql server. plz help me i need to submit my project on 25th of this month. i am left out with only this form :( or … |
| | Hi everyone, First of all let me just tell you that I have never done database programming myself, and this is the first time I'm setting up a MySQL database via phpMyAdmin, so I could be missing something small but I'm sure someone will know the answer, anyways... I have … |
| | Hi, everyone... I have a question about sql .. Question: Customer | jan-april | may - august| september - december A |quantity | | B | | | C | | | How to use the SELECT command to retrieve data and the output is show like above. please give … |
| | Hi all, I am attempting to connect to a MS SQL Server Express Edition with Advanced Services (MS SQL10) on a remote Windows NT 5.2 machine on the LAN. My driver is [B]net.sourceforge.jtds.jdbc.Driver[/B] My url for the connection string is [B]jdbc:jtds:sqlserver://127.68.0.201:1433/LOD[/B] My user is [B]d[/B], password is [B]d[/B]. Now, when … |
| | Hi I want to load data from a flat file into a SQL table. The file has a header row and detail rows, all of which need to be loaded. I've tried various suggestions I came across in forums and EndOfStream is the one that loaded all the rows. The … |
| | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 keep getting this error what do i do  |
| | I am having a bit of difficulty in getting the right value. What I want to query is, the users who expire in 7 days, for example on 4th Oct 2011, the query should display the result of that particular day only. Right now I am querying as below: select … |
| | hay this is samar here actually i have to get values from tha my sql foe a perticular string which i pass through a xt box i think i'm not able to pass the vehicle no. to the querry this is my cade pls help [code]package p2c; import java.awt.Container; import … |
| | I'm sorry if this should have been posted in the c# forums..... I have created a database for my website and am using MS SQL. This database will need to be accessed by users on the site itself, and from a .NET application. I am comfortable using MS SQL through … |
| | i have an existing database and i want to attach that database one time to sql server and when thee database is attached then it open that database  |
| | Hi, i am just adding the last component to my registration page, but i am having a little trouble with it. Basically my website includes a referal based system, wherebye when the user signs up they can add a referal that benefits the referal later on. The code i am … |
| | Hi all, I have this code that seems to work fine for the order but cant get it to pass the invoice side of things. the trouble im having is when i do the order its fine, but when i do an invoice it sends me back to the order … |
| | I'm attempting to create a program where the login and password will be verified on an SQL database of user information. I keep getting the error "SQL Execution was unhandled" I marked the code that was causing the error in red. I'm using Visual Studio 8. Keep in mind I … |
| | I'm attempting to create a program where the login and password will be verified on an SQL database of user information. I keep getting the error "SQL Execution was unhandled" I marked the code that was causing the error in red. I'm using Visual Studio 8. Keep in mind I … |
| | hi all, i have a problem with multiline json file that i wish to insert into an sql db. my problem arose as i went from one data set to two in the JSON file. the one data set was sucked from the json file to the sql db via …  |
 | Hi Guys, I have imported an excel document into MySQL to tidy up and make better use of the data but I am having problems running an update. All tables used as examples below; [U]Tables[/U] asset_register phone sim team The asset_register contains the following cols; [CODE] id INT, serialNo VARCHAR, … |
| | Hi , i'm doing a project which invovles time and attendance management. When i download datas from the biometric reader , i got the records in the following format, empCode date time 5001 12/09/2011 09:05:34 5002 12/09/2011 09:33:13 5001 12/09/2011 13:05:53 5002 12/09/2011 13:22:24 5001 12/09/2011 14:05:22 5002 12/09/2011 14:33:53 … |
 | I have one Access Database and in one of the column I need to store image file, how can I do that? Can anyone help me. I know how to do this is MS SQL Server Database but not about Access Database. |
| | i want to search name form table but problem is tha when some one write query it also give value by this any one can delete my data to pls tell me a way to remove sql injetcion [CODE]protected void Button2_Click1(object sender, EventArgs e) { //SqlCommand cmd = new SqlCommand("DELETE … |
| | This is homework. Here is the problem: Produce a list of employee last name, first name and department name. Use appropriate, user friendly column aliases. This is from the tables [ICODE]DEMO.EMPLOYEE[/ICODE] and [ICODE]DEMO.DEPARTMENT[/ICODE]. The relevant column names are [ICODE]LAST_NAME, FIRST_NAME, DEPARTMENT_ID[/ICODE] (from [ICODE]DEMO.EMPLOYEE[/ICODE]) and [ICODE]DEPARTMENT_ID, NAME[/ICODE] from [ICODE]DEMO.DEPARTMENT[/ICODE]. As you … |
| | im having the same issue with the above "You have an error in your SQL syntax; check the manual that corresponds to your MySQL...line 1"..help! myform2.php [CODE]<? ob_start(); ?> session_start(); <?php $labels = array ( "comment" => "comment", "condition" => "condition", "cartype" => "cartype"); ?> <?php if($_POST['Submit'] == "Submit") { … |
| | I not sure how to do this.Could anyone can help me...? question: Display all buyer (code, name) who has average purchase each year for more than 100000 for past 10 years here is my query: [CODE]SELECT b.CODE, b.NAME from ( SELECT BUYER, AVG(TOTAL) AS total FROM SMF WHERE TOTAL > … |
| | [B]hi , i got an error.pls help me to correct. my code is[/B] [CODE] <form action="return.php" method="post"> <table width="200" border="0"> <tr> <td><h3 align="center">RETURN</h3></td> </tr> </table> <p align="center"> </p> <table width="41%" height="254" border="0"> <tbody> <tr> <td width="34%">Author:</td> <td width="66%"><p> <input type="text" name="author1" /> </p></td> </tr> <tr> <td>Title:</td> <td><p> <input type="text" name="title1" /> … |
| | Hi, Am created a login and an user to access sql server instance and the database. [CODE]Creating Login: create login xxx with password='secret'; Creating User: use testdb; create user yyy for login loginname; [/CODE] And then i login with this login name(xxx) and also i can able to access the …  |
 | I found an old thread that had never been answered here - [url]http://www.daniweb.com/software-development/vbnet/threads/330981[/url] Basically, the guy was asking how to retrieve database names and/or table names from a MySql database with vb.net. Here's my answer to that. Yes, I still use vb6 because vb.net is not much better and I … |
| | how Save, Update, Delete Data using C#.Net and SQL Server 2005  |
| | |
| |
The End.