6,934 Topics
 | |
 | Hi i keep getting an exception when i'm trying to update table values within a database. the exception is below but i dont change from datetime to varchar it always stay as datetime. is there any other reasons why this is happening ? "The conversion of a varchar data type … |
| | I am able to save an image from a picture box into the database of SQL. I used a byte array and filestream to read the image. [CODE]FileStream fs = new FileStream(imagename, FileMode.Open, FileAccess.Read) byte[] picbyte = new byte[fs.Length] fs.Read(picbyte, 0, System.Convert.ToInt32(fs.Length)) fs.Close()[/CODE] For some reason, I can't retrieve the … |
| | Hi, Not sure if my question belongs in an ASP.NET or MSSQL forum.. I have an ASP.NET webpage built in VS2010 with an Input field with the functionality to browse to a network directory, select a text file, read content and upload the data to an MSSQL database table. Nothing … |
| | I would like some help on this database design I need to have completed by next week. Here's the specs: I'm creating a custom PC builder application. I've been getting stuck on trying to create the database for it. I would like to be able to enter customer details then …  |
| | [code] private void btnBackup_Click(object sender, EventArgs e) { Backup bkp = new Backup(); this.Cursor = Cursors.WaitCursor; this.dataGridView1.DataSource = string.Empty; try { string fileName = this.txtFileName.Text; string databaseName = this.ddlDatabase.SelectedItem.ToString(); bkp.Action = BackupActionType.Database; bkp.Database = databaseName; bkp.Devices.AddDevice(fileName, DeviceType.File); bkp.Incremental = chkIncremental.Checked; this.progressBar1.Value = 0; this.progressBar1.Maximum = 100; this.progressBar1.Value = 10; bkp.PercentCompleteNotification … |
| | hi, I have a browse button for sending single image with other text inputs in jsp type I have chosen Multipart-Form data . I got 'parameter not set error' for blob field. I am using MySql database. I am using DefaultFileItemFactory clss [CODE] FileItemFactory factry= new DefaultFileItemFactoy(); FileUpload upload= new … |
| | Hi, I'm making a printable Purchase Order form using Crystal Report. This report retrieves data from two tables. Example, I have fields PONumber,DateofPO,Airline,DateofFlight,ETA,ETD from a table called tblFlight. I have fields PassengerName and Rate on another table called tblPassenger. Each PONumber can have multiple passengers. How can I get it … |
| | Hello, I have installed vb .net 2008 express and sql server 2008 express, vb .net 2008 express install (with no option of custom install) sql server compact enu. When I try to create an ado application I see no option for the sql server to insert an ip (like sql … |
| | Hello, I am trying to set a maximum records to "take"-"pool" from an sql server because I get an error out of memory when I try to navigate through all records in a 1.60 gb database, is there any option anywhere that will allow me to specify a max number … |
| | Hi, I am trying to generate an sql query to insert several pieces of data, most of which comes from another table, however I have one variable that comes from PHP variables as below: [CODE]insert into scores (AuditID, question_id, available_score, question, question_number, question_section) values ($auditvalue, (SELECT questions.quid, questions.question_value, questions.question, questions.question_number, … |
| | Hi everyone, I'm in a spot of bother. Attached is an image which should help better show what I'm about to ask for assistance with. :) [url]http://img96.imageshack.us/img96/7624/sqlm.jpg[/url] What I have, is 2 tables that associate each other with 'packholder' In the table shown, you can see Packholder - 1, 2, … |
| | hi, Below is my code to delete the transaction. It suppose to delete the data once the transaction but the data remain there....I don't find there is a problem with the code but some how it doesn't work. It capture the data in the table but it returns = 0 … |
| | Hi All, I'm a fairly new programmer so you'll have to bear with me on this. Basically, I have a database with 3 tables, Engineers, Equipment and Signouts. I want to create a VB application that allows engineers to sign out equipment. I have all of the forms setup the … |
| | Hey guys, ive bin following someones tutorials on how to connect and view data in a sql databse table. Does anyone know how to send data from say two textboxes to the table, say Name and Gender Heres the working code I have at the moment. [CODE]Imports MySql.Data.MySqlClient Module SQL … |
| | Hye I have a question: Suppose I use JDBC, JDBCTemplate in order to execute a sql query. The query is something like: query = "SELECT ... FROM ... WHERE user = ? AND password = ? AND x='valuex' AND y='valuey' ..." Where user,password - I got from the web user … |
 | I have two tables representing two forms that are connected each other but a form number. The second form records a number and a timestamp. This form can record multiple entries with a timestamp for each entry. I need a SQL statement that will return the first entry on Form2 … |
| | When I execute my php script with this sql code: [CODE]$key = "aaaabbbbccccddddeeeeffffgggghhhh"; $con = mysql_connect($sql_host, $sql_user, $sql_pass) or die ('Error connecting to mysql'.mysql_error());; mysql_select_db($sql_db, $con) or die("Could not select $sql_db"); // To work in "utf-8": $query = "set names 'utf8'"; $result = mysql_query($query); // Query: $query = "UPDATE personaldata …  |
 | Hi everyone, I am getting this error: [CODE]Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated.[/CODE]please …  |
| | hi i have a question in getting values from two table i ave two tables Table1 and Table2. table 1 have data and table 2 may have the same data as table 1 and more. and also table 1 may have the same data and some which is not in … |
| | I have a database designed and implemented using ms sql server 2005. initially, the user has entered the pictures with a very big size because there was not restriction. now when the user is opening the crystal report so it takes alot of time and some time memory full problem … |
| | i m trying to update a table in my sql database using stored procedure. i have executed my stored procedure and dat works fine, no problem in that. i knwo because the values are updated when i execute it. however when i try to do so through asp.net code that … |
| | Hi to all, I create the following table. create table man(id integer, name varchar(20), city varchar(20), age integer) I want the age, maximum age of person. So, I ran following query, select name, max(age) from man group by name; It shows name of all person in ascending order with their …  |
| | I have a table in which i have a column named "dtCreated" which has got datatype as VARCHAR(50) Now I want records between two dates. I wrote my query as written below [CODE] select * from mytable where dtcreated>=fromdate and dtcreated<=todate [/CODE] This query work fine when fromdate and ToDate … |
| | Hi to all, I have nothing idea about how to create relation and solve their queries. I want to relation as follows: ------------------------------------------------------------------- BookAuthor(book, author, earnings) BookReference(book, referenceBook, times) BookReview(book, reviewer, score) BookPublih(book, year, publisher, price, numbar) In these database, each book may have 1 or more authors & each … |
| | Hello all, I want to use code behind variable in mysql command in aspx file here are the codes[CODE] [U]code behind[/U] public vgroup as string vgroup ="1,7" [U]in aspx [/U] <asp:SqlDataSource ID="SqlCategoryList" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT * FROM categorymaster WHERE catgroup in ('<%=vgroup %>')"> </asp:SqlDataSource> [/CODE] … |
| | Hi to all, I created the following two table -------------------------------------- create table mail(mid integer primary key, name varchar(20) ) create table phone( pid integer foreign key references mail(email), phone integer) ----------------------------------------- After inserting records on both table, now i want delete perticular record from table say 'delete record of pid=12'. …  |
| | Hi, Currently we are using asp.net 3.5 with sql server 2005. We are display the sql server image in to <img> tage.It's diplay in IE 6 lower version,but in IE 6 higher not working.this is actual coding we are using [CODE] Dim myDataReader As SqlDataReader myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection) Do While … |
| | I have a Windows SBS 2008 system. Occasionally, When I look at the daily report it shows that status of updates as unavailable. The status may be fine for up to 2 weeks or I may get this message every day for 4 or 5 then it disappears for a … |
| | [B]hi guyz..! i want to know da process the to configure sql server on client pc..using odbc...i have install sql server 2000 advance server on windows xp platfrm... i m trying to configuraing frm so long ...bt m failed..! kindly help me regards[/B] |
| | I have an existing database design which I would like to normalize. Essentially, the table causing me problems is one with about 150 columns. The table holds live data for a natural gas well. So, there are columns for the various temperatures, pressures, etc. The data types of these columns … |
| | i am using the following code to submit a form: [CODE] <script> function marktaskcomplete(){ document.forms["markcomplete"].submit(); } </script> <? if ($_POST['markcompletevalue']=='yes'){ include "dbconnect.php"; $taskid=$_POST['taskid']; $query="UPDATE tasks SET status='0' WHERE uid='$id' AND id='$taskid'"; $result=mysql_query($query); if ($result){ echo "<script>location.href='?goto=taskmanager'</script>"; }else{ echo"fail"; } mysql_close; } ?> [/CODE] and when i try to submit more … |
| | Hi, I am new to mysql and have got a problem. I have managed to INSERT into the database and and check from it (a simple login system) but now after i login i want to copy all the data from that row and throw it into an arraylist. I … |
| | hi!!! i have got a small problem wid an sql query that i m writting in jsp the query is real simple... but i dont know y m not gettin it... [CODE] q="select '" +col+ "' from '" +ta+ "'"; Class.forName(sq.getName()); cn=DriverManager.getConnection(sq.getConnstr(),sq.getUser(),sq.getPwd()); st=cn.prepareStatement(q); out.println("before query1"); rst=st.executeQuery(); [/CODE] [CODE] q="select ? … |
| | Hi, I was told to build a application that will encrypt data and migrate data from one database platform to another platform. Please i do not hae a clue where to start from as i am a newbie to database. Any info will be well appreciated |
| | I read an article about versatile webcam and I successfully worked it out. The thing is I can't save the image from the pictureBoxDisplay to SQL. Please I really need help on this. I'm converting the pictureBox into a byte array but there's an error in this line (line 123), … |
| | Hi, am SQL beginner, now i trying to code student marks management so i came across to db i was confused. Please give idea to create such thing, i have students, mark tables as per the semester. then how i place the information according to register number. so that how … |
| | How do you replace characters as in an update? Example I have an address field that contains '.' and '-' and I need to remove these characters. Anyone know of an update script to do so? |
| | I have a set of code that builds a table as the user enters information. This information may be changed more than once before it is considered complete. After the user is done, I want them to click a button, and have that information entered into the SQL database where … |
 | Hello Guys, My problem is When i'm trying to run this program Sql QUERY doesn't work properly , but the month and day are okay but it comes to year it doesn't work... :( anybody can help me please? thanks [CODE] Dim strSql As String = "SELECT * FROM tblAudit …  |
| | My question is, if I want to upload 4 files at a time do I néed to store at my database all 4 filesize type and path or can I get away with only storing the file name and upload them. Thanks |
| | Hello Guys, My problem is i don't know how to query TOP ORDER PROD using COUNT,AVG... anybody can help me please? thanks ^_^ [CODE] EXAMPLE -LIST OF ORDER'S- ITEM CODE | ITEM NAME | 4323 PROD A 4323 PROD A 4323 PROD A 4323 PROD A 4323 PROD A 2345 … |
| | Hi everyone Im trying to take my SQl and "SCRIPT" it to a .sql file(accomplished) and add it to my Delphi(accomplished) and then [U]connect them[/U] and show the data in a TDBGrid but seem to be battling. The .sql file adds and creates the Database in delphi but I don't …  |
| | i have a project, where i have a menu, in which option Customer info, where all the basic information of customer is stored...and blow there is another menu, whre Asset Servey is menu, now i have a text box in wch customer with its code is shown, now i want …  |
 | Hi there, my name is Stéphane, i'm french and a beginner with Python... I've registered on a french forum about Python to ask a question regarding an issue i have with a code, but it seems the members of this forum are not active. I paste the message i posted … |
| | Hi there guys really hoping for some help after searching Google for a stupidly long amount time and coming up blank. I am using Crystal Reports 10, Asp.net 1.1, SQL Server and Visual Studio 2003 with VB. I have an Image field in the database that I need to retrieve … |
| | I need help troubleshooting a performance issue. I have a stored procedure that is selecting from 3 joined tables, and is hanging on the first time this procedure is running. Sometimes hanging so long that I get a timeout error. After the first run, it's faster, but still takes longer … |
| | I know sql provides us with LTRIM and RTRIM but is there anyway to remove the spacing in the middle. '123 Johnson St' should be '123 Johnson St. Anyone know of any functions or tricks? |
| | I made an windows application using c# express edition 2010 and i use the SQL database as mdf file inside my soultion and the connection string mad automaticaly in the app.config as the following: [CODE]<add name="MainForm.Properties.Settings.FamilyHistoryConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\FamilyHistory.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />[/CODE] then when i am trying to publish the … |
| | Hi all, I'm currently make my final year project program at university, and have been puzzled by this problem for sometime now. The issues I am having is that when I try to update a value in a specific column of a specif row. The program has a paddy and …  |
The End.