1,694 Topics
|
|
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 ? … |
|
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 |
|
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 … |
|
<?php echo '<?xml version="1.0" encoding="UTF-8"?>'; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>age.php</title> </head> <body> <?php require_once( 'output_functions.php' ); function connect_to_database( $host, $user, $password, $dbname ) { // Try to connect to database $dbconnection = mysql_connect('......', '...', '.....'); if ( ! $dbconnection ) … |
|
I'm looking for cool code editors for Windows 7 Ultimate 32bit. If you have any please tell me! I am using... [LIST] [*]Adobe Dreamweaver CS5 [*]Intype [*]Notepad++ [*]ConTEXT [*]Notepad 2 [/LIST] I don't really give a frogs fat aśś when it comes to how heavy the program is. Whether it … |
|
HI All.. I want to develop a dynamic time table for a school. But the subjects and periods are not fixed ...so there can be any number of rows and columns in this which will be decided by user at runtime. when user enters number of row and columns according … |
|
in a database for a company,what technology is best for enabling for examples certain staff memebers to make bookings/access the database from any location using a **Browser**? how do i implement this and how can i make it work? please HELP! p.s i have been researching and thinking creating a … |
|
My hosting provider assigns the server name, database name, user name and password after I import/upload my SQL server database to them. When I run locally for testing it will be different. How can I effectively test and publish my site without having to change this all the time? |
|
Hi there, Does anybody know how to refresh a windows form after inserting into a database using a dataTableAdapter or any other method for that matter without having to close the form or use the fill method to reload the form? The problem with this is that you are taken … |
|
hi.. i'm having problem w/ my [COLOR="Red"]UPDATE SYNTAX [/COLOR] .. I CAN'T FIGURE OUT WHAT'S WRONG WITH MY SYNTAX.. PLEASE HELP ME.. I REALLY NEED TO FINISH THIS FOR MY DTR SYSTEM THESIS.. i can't move on to my other codes.. please... --the error that i get is.. UPDATE SYNTAX … |
|
Hello Friends, I am new to .NET and to this forum too. I need to move approx 2K rows from an oracle to SQL server table every week. I am planning to develop a C# console application to achieve this. Any ideas how to start and what is the best … |
|
i have this code and it kinda works but not properly. i need it to look at the coloum in a datagrid and make the back colour red if over 1.6(in sql this field is saved as Varchar(10)) but at the min, i have a value of 1.5 and it … |
|
Hi! I need to be able to change the location of the database at runtime through a menu in my program. My question is how to best achieve this. If for example the ip to the server change, the user need to be able to update the database path; i.e. … |
|
I have the following set of tables but I don't care for the design. It seems like there should be a better way of doing this. Let me explain what's going on: -A visitor comes to our website and has the option of inputting a promotional code when buying our … |
|
|
Hi I am having some issues with sage pay php form integration. I have built a shopping cart that selects product information from a database and am having issues integrating it with the kit. When I test against the sage servers, everything passes except the cart contents. Is there anyone … |
hi there i have a database called employee and in that there is a table called EmpDetails and in that there is column namely firstname awhat i want to do is to return all the first names in the database. i am using the 3 tier architecture. from the dbcommection … |
|
Hi I am having trouble trying to normalise my tables, I would really appreciate some help! So far I have: [B][U]Customer Table[/U][/B] CustId(pk) Cust Name Cust Address Cust Postcode Cust Email [B][U]Order Table [/U][/B] OrderID (pk) Order Date_Time CustID(fk) [B][U]OrderDetails[/U][/B] DetailsID(pk) Quantity OrderNo(fk) DeliveryID(fk) [B][U]Product[/U][/B] ProductID(pk) ProductType ProductDescription DetailsID(fk) PartID(fk) … |
|
Hello my friends. I've been dealing with a problem in an asp.net page that im developing. Generally I don't develop in ASP.NET i prefer desktop applications. But here is my problem, I have to create a kind of image wall (4 Faces in a 2x2 row), i'm almost done with … |
|
Hi all i have been dancing around this problem for a couple of weeks now and have not got any closer. Description: i have created a crystal report in SQL5 and exported it fine but now i have gone to open it in visual studio 2008 and it does not … |
|
Hi I want to convert Sql Server Database to Access Database , I have one database and it has different tables and view also. please help me how to do this ? |
|
Hello all, I’m getting one strange error on my web. The web was developed with spring and has a tomcat pool connection configured for Oracle DB. After upload the web content into the server, when restarting the server and trying to open the web page, first time display error: [ICODE] … |
|
Hi there, how can i create an executable so that anybody can install in their own computer? I want to create from visual studio C#. please give me a tutorial or something, i did some but it didn't work properly please help guide in this thanx |
|
I can find a lot of information about the concepts of normalization, but I don't really see documentation for how to actually bring a table, for example, from first normal form to second normal form. I'm using SQLite through Python to automate some data processing, and I have three input … |
|
[CODE]select PREMISEADDRESS1 from PREMISE PREM inner join STATUS ST on PREM.LOCATIONID = ST.LOCATIONID inner join SUPPLIES SUP on ST.STOPID = SUP.STOPID where SUP.ITEMID [COLOR="Red"]=[/COLOR] (select count(ITEMID)[COLOR="Red"] > [/COLOR]10) from SUPPLIES) [/CODE] Hello, I do not use SQL all that often but I would like to view all of the premisesaddresses … |
|
Buddy , i have problem in to combine sql with c++ plzzz any one help for this issue hurry friends i have a library project to combine it with database. hellppppppppppp meeeeeeeeeeeeeeeee............. |
|
Hello everyone! I'm wondering if there is a way to assign the values of a column in SQL as the key name in a multidimensional array. Here is what I have, my database looks like this: Table Name = SJCFPCB date | totalin | cdulep | icu | ----------------------------------- 2011-01-27 … |
|
I can't insert values into a table using a stored procedure because the fields are of data type MONEY. First, is the data type CURRENCY the same as data type MONEY? Right now, I am currently using the integer value of adCurrency for the data type parameter of the createparameter … |
|
hi.. i'm using ssrs 2008 enterprice edition.. i want to send a report as email.. to my gmail address.. i want to schedule a report so that it can deliver daily to my gmail address.. how to send the report to my gmail address.. i dont know anything about smtp … |
The End.