6,934 Topics
 | |
| | can you please help me to create a adding form and it will save to sql database .. pleas  |
| | Hi All, I have a problem I have a MySQL Table, one of the columns' Data Type is TinyInt(1) When I use this line of code it gives an error int newNumber = int.Parse(string.Format("{0}", reader["someField"])); I think the reader is reading a bool value however MySQL Table has row values …  |
 | I'm creating a search function for my program, and need some help with SQL. Until now I have been using simple SQL query like [CODE] "SELECT post1 FROW table1 WHERE a=b" [/CODE] and put it into arrays. Then using that info to do another query, put it into arrays, and …  |
| | Hey All I would like to know how to retrieve a image from sql server database. im storing the path in the database.. |
| | i had created login form in vb.net there are two fields username & password.i want to check username & password enter in the login form,from the first.mdf(database file). if it is correct then message is displayed i had written code for this but i got error in the code.what modification … |
 | Please let someone help me out here, i want to insert record to the database using VS2010, when i input data to textboxes and hit button, the program will run and tell me data inserted succesffuly. But when i check my dbs table i won't see any thing. here is …  |
| | Hey everyone, kinda new to all this...really need some help: Ok so I want to creat a log in and registration form in VB connecting to a sql database. Databse Name: Users Table Name: UserDetails Table Fields: ID, Username, Password The ID field was specifed as primary and self incrementing … |
| | I'm working on a C# windows program with Visual Studio 2008. Usually, I work from school, directly on my usb drive. But when I copy the folder on my hard drive at home, and I run it from my hard drive at home, an sql exception is unhandled whenever I …  |
 | Hi all, I am getting an error in my application that reads: Incorrect syntax near the keyword 'set' It only occurs in a database at a particular venue and only when the offending query/queries are run locally. I have restored the database on my PC and the queries run without …  |
| | |
| | I have a JAVA method that executes the following query to SQL server database SELECT [CHEMICAL_NAME],[CHEMI_UNIT],[PRICE],[VENDOR],[CATEGORY]FROM [RPS].[dbo].[Chemicals]where CATALOGNO = '" + catNo+"' ;"; Following are the column names of the database table CATALOGNO, CAS_NO, CHEMICAL_NAME, CHEMI_UNIT, PRICE, VENDOR, CATEGORY, I get the above mentioned error "com.microsoft.sqlserver.jdbc.SQLServerException: The column name CATALOGNO …  |
 | OK so I have a decent database that I have set up with all the correct tables and relationships, but now I have another issue, and that is distributing it. I don't know how to achieve what I am after. I know how to install SQL Server Express during my … |
| | I am trying to connect to crystal report from Visual Studio 2010 but i realised my SQL database should have SQL authentication (i.e requires user and password) instead of windows (which was assigned by default). I have tried several approaches to achieve this without luck. Will appreciate some help. |
| | I am getting this error that I can't quite wrap my head around. The code segment calls a mysql stored function that basically assigns an available id number. This is the code: [CODE]try { CallableStatement call_proc = conn.prepareCall( "{ ? = call getAvailableId(?, ?) }" ); call_proc.registerOutParameter(1, Types.INTEGER); call_proc.setString(2, tableName); … |
| | I am trying to connect to crystal report from Visual Studio 2010 but i realised my SQL database should have SQL authentication instead of windows. I have tried several approaches to achieve this without luck. Will appreciate some help. |
| | I have written an SQL query to return the total quantity of products ordered and total price. The query returns a result for each order in the range I have specified.Please find attached the output i am getting. the desired output i want is as follows: (year,productcode, productname, orders, quantity, … |
| | I have this servlet code for retrieving contents from database and displaying it on the browser.But when I am running this code it is giving "ClassNotFound Exception" at Class.forname().I have built the path with db2jcc.jar and db2jcc_license.jar file but still this exception is thrown.Please help me [CODE] import java.io.IOException; import … |
| | HOW TO WRITE SQL USING CRYSTAL REPORTS 9 IN VB6? Dear Friends, I designed one INVOICE crystal reports9 using vb6 and connected with access database. It was displaying all the records. Now i want to display particular invoice number. I used below code. but its not executing. default code only … |
| | Hi, As the title states, I have a query that I use to concatenate all the rows into a single string and I use the XMLTransform method to accomplish that but I still need to add a new line separator within the XML string and so far I didn't find … |
| | I am working on an ERP based project which was created using asp.net(3.0)c# as the front end and sql server(2005) as the back end. We have completed the project but after installation on the client location, when Multiple users Login and use the same form to perform a transaction, then … |
 | Hi there, since recently i have been trying to master HTML, and now i am full ready to take on PHP therefore, just like HTML instead of making many .html files | i want to use the PHP dynamic page function that can show me pages from database. usually as … |
| | If I have SQL authentication enabled, and a user (UserA) on a database has permission to delete rows on TableA, but not TableB, and there is a relationship between TableA and TableB, can UserA successfully delete a record on TableA and have the changes (based on relationships set up) cascade … |
| | Hey guys, I am writing a web application in asp.net using c sharp. I have a web page that lets the user create a program. In this system a program is made up of many applications and an Application can belong to many programs hence a many to many relationship. … |
| | this is the code to email confirm. The user clicks on the link in the email, passing the code through url to this page. Then the data is transferred from a tmp table to main one. I have queried in phpmyadmin and it works fine. But when i actually use … |
| | hello...i just installed oracle 10g in my pc but i dint get username and password for sql*plus......plz help me |
| | Hi everyone here, Can someone please guide me in transforming XML-to-SQL output with Python? I need to create 2 tables (Books and Patrons) into SQL. How much i suppose to start with??? <?xml version="1.0" ?> <Books> <Item> <BookID>A001</BookID> <Title>A Tale of Two Cities</Title> <Author>Charles Dickens</Author> <Language>English</Language> <Year>1859</Year> <Quantity>5</Quantity> </Item> <Item> … |
| | can you give me some search engine code. i am using sql server .. thank in advanced |
| | Help me how i connect a sql server 2005 or ms access database with trubo c++ |
| | I am trying to populate a drop downlist on my page with data in flightnum from the table Air_Flight, my dropdownlist keeps having System.Data.Datarow in the dropdownlist. Im pretty sure im one line of code away from getting the actual values in the dropdownlist, I am just not sure which …  |
| | Hi With the following script [CODE] <html> <body> <?php $server = "localhost"; $username= "root"; $password ="mysql"; $connect_mysql=mysql_connect($server,$username,$password); if($connect_mysql) { echo "Connection Established"; $mysql_db=mysql_select_db("mysql"); if($mysql_db) echo "<Br><Br>Connected to database <BR><BR>"; echo "<Table>"; echo "<TR><TH>Employee_ID</TH><TH>Employee_Name</TH></TR>"; echo "<DBQUERY q>select emp_id,emp_name from employee"; echo "<DBROW><TR><TD><? q.emp_id></TD><TD><? q.emp_name></TD></TR> "; echo "</DBQUERY>"; echo "</TR>"; echo "</Table>"; …  |
| | I'm trying to set up a simple little rating system for videos on a website. If you push + it adds 1 and if you push - it subtracts 1. I've got it working just fine. However, the way i'm checking to see if you've rated it already is by …  |
| | Ok i'm trying to build a forum with jquery ajax characteristics. Below is the html/jquery coding. And i know jquery is loaded because I did the [ICODE]alert(1);[/ICODE] inside the document ready and it worked. [CODE] <!doctype> <html> <head> <title>Shouts!</title> <script src="jquery.js"></script> <script> $(document).ready(function() { $("#messages").load(function('loadchat.php'); $("#post").submit(function(){ return false; }); }); … |
| | I am building a website that hosts and streams videos. I am currently testing the site on my own server. I would like to host it remotely once it is going live. I am looking for a good and reliable hosting service that provides necessary resources for online video. The … |
| | please tell me how to convert a sql file which contain a table into .csv file in sql please tell me whether there is any c program to do this conversion or any other program insql for doing this |
| | Hello, I have developed a site in VB.Net and ASP.Net with a database backend that allows a user to enter a centre code and in return it retrieves all records from the datbase where the centre code matches the one provide in the text box. My list is appearing as … |
| | It is catching my exception error when I try to do a select student_id student_name from Student and put it in my dropdownlist. I already created the databases called college and tables Student, Course, and StudentCourse and put in fake data. I store my Connection String in the web.config file. … |
| | Who can help me? I always get error to connect my project in vb.net to sql server on remote computer?? |
| | i am having an sql query in catch block. the code is: [CODE] Dim str_exception As String = ex.Message Dim sql5 As String = "insert into table_data(type,description) values('ERROR'," + str_exception + ")" Dim cmd_sql5 As New SqlCommand(sql5, connection) cmd_sql5.ExecuteScalar() [/CODE] it throws an exception at cmd_sql5.ExecuteScalar(). the exception is - … |
| | Can you all tell me the difference in these 2 codes? I'm trying to learn JQuery and ive seen this code below in the tutorials. [CODE] $DB->Query("Select * FROM time"); [/CODE] I'm use to coding queries like this. [CODE] $res = mysql_query("SELECT timestamp, name FROM time ORDER BY timestamp DESC"); … |
| | Hello everyone! I have a problem trying to get a user to be able to query the database with only the fields and specifics they want. Basically... User logs in, browses through record entries and then wants to see how many of the entries are under the age of 21 … |
| | Hi, I am developing a system for a business and would like the server to be one of the computers of the organisation. My problem is that i don't know how to make the database accessible by the other machines. Thanks in advance. |
| | Okay so I've searched just about everywhere but can't seem to find what I'm looking for. I'm learning as I go with PHP and I'm having a problem figuring out what is wrong. I've got two different queries calling a group of information. Within each query is a field that … |
| | Hello to all, I have installed SQL Server 2005 on windows xp . Please tell me how can i create new SQL database ?  |
| | Can someone help stop my head ache! Im sure its very simple (it is with php). I have run one query to get a users current cash [CODE] SQL = "SELECT * FROM money WHERE id='fred' Set Recordset = Server.CreateObject("ADODB.Recordset") Recordset.Open SQL,Connection Recordset("cash")[/CODE] This is correct and pulls the value …  |
| | If I have 2 or more tables and I need to have another table that is related to the data in those tables...how would I achieve that? As an example: Table A and B have totally different data and aren't directly related at all. I would like Table C to … |
| | Hi, Can you help me please I am still beginner in the IBM data studio,my problem is that i want to use the existing table in the SAMPLE database,I want to querry on the 4 tables,like in employee table or etc...in using the stored procedure can you help me please …  |
 | hey guys up until recently i had VS 2010 and sql sever express 2008, and then i upgraded my sql server to enterprise version, then i could not access any data from my database file which i had created with my sql express version, when i tried to connect to … |
| | i know how to save a text file to a sql database, the problem is on when will be the process is executed because i need to monitor the operation of an existing system.. |
| | I built a quick date time test page. The coding is below followed by its results. I'm entering the raw timestamp into table time because i want to be able to manipulate it once i show it (say if i want to show time and date using the same timestamp). … |
| | Is it possible to move the "description" column to the right of the "Allow Nulls" column in the table designer so you can see the descriptions for each table column without clicking through them one at a time? Like the attached picture? Please, someone, for the love of all that … |
The End.