6,934 Topics
 | |
| | Hi all, i have difficulties in appending my sql query in php. Need some of your help to guide me along. Tell me where does my code goes who. Thanks. for ($i = 1; $i<=$dayc; $i++){ $daya[] = $_POST['day'.$i]; } $link = mysqli_connect($HOST,$USERNAME,$PASSWORD,$DB); $query = "UPDATE class SET Time_Slot_idTime_Slot = … |
| | Hello, I don't have technical problem. I was just thinking the difference between arrays and SQL. I am currently learning OOP in java and C# but my employment history is based on SQL Server. So I was thinking about this subject in my head and I don't see why bother …  |
| | The code below is my insert statement to get values into my database. However, I now have an update page where users can update their information. I thus have a form in which their initial info is inserted and now they can change it and submit again thereby updating the … |
| | I am using the .Net 4.0 and excel 2003 How can i use an oledb connection to retrieve the cell format of an excel spreadsheet... I specifically want to find out if a cell column (or cell itself) is in a numeric percentage format. I cannot seem to find this … |
| | I have an application that uses an *.accdb file as the back-end database. Connecting to and retrieving data from the access file is not an issue and is working quite well. However, as a precaution, I have the application first check to make sure the database file exists in the … |
| | Really I am a PHP beginner, I am working on this code and I need help, kinda stuck. I have a database with 3 fields(id, date and venue). This is simply what I want to do; I want my script to go into the database fetch the date and compare … |
| | Hallo guys, a theoretical question I have there for you. I have a search form in HTML with several input fields, so the user can search for particular features in a db. My queiston: How can I generate a dynamic query, depending on which fields the user had filled in? … |
| | Hi I have encountered the following error: Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in I don't know what is exactly the local host: shell I use only my domain or I need to use a special path...I would appreciate if somebody can help on this. Thanks! … |
| | Hi, I got a question to check if a date time is within another date range (So as to check conflicting schedule) There are various possible types of schedule: 1: One time start - end event. Typically such schedules is like a tour / outing / camp event, and hence … |
| | Dear Experts, I am building a program which needs to store an Image (any image type) in SQL Express 2008. I am able to read, and insert images into SQL Datatable, but I can't seem to update my images. The SQL DataTable contains columnname "picture" - Varbinary(Max) I am using … |
| | How can I secure SQL SERVER 2000? I am using windows authentication mode and it doesnt have additional user name or password. As a result anyone can open SQL SERVER 2000. I need to know how can I secure it so that none can open & edit data from enterprise … |
| | Hi all, I have a pagination script that works great apart from one last thing I require some pointers on please. The help i need is with the SELECT query - currently the select query works, but i am bringing back all records, I am trying to bring only certain … |
| | Hi Guys I Have a table with 2 fields & several roows like this : Cd val -- --- a 1 b 2 c 1 d 3 f 4 g 2 h 3 k 5 l 6 m 8 n 7 o 1 p 2 I want get the result … |
| | Hi! I'm trying to create my own little community for learning purposes and I'm having some trouble with getting the data I want from the table. I'm not that high on SQL but I know the basics but when you get into the more complex mysql-lines I get lost. The … |
| | Hi, this is my query [CODE]$result = mysql_query("SELECT SUM(`qty`) FROM sims_ac WHERE region ='North'");[/CODE] How I can show this [CODE]$result[0][/CODE] without using While loop or any other loop.  |
| | hi friends, can u please help me the code how connect to SQL server in vb.net using c#.. i m waiting for your help |
| | Hello, for a database project (music festivals) several search options are to be included. While some search fields will be filled from a dropdown list (like "countries"), other will have a fuzzy option (like "song titles"). For this I want to use the full-text search (you may remember the words … |
| | Hi! I need some help please! I have to create a DB that has to be normalized to 3NF. I have a table 'Products' that contains info about all the products - product_ID, product_name, quanitity (left in warehouse), procurement_price, sales_price. And I have [B]TWO[/B] more tables that contain info about … |
| | Hi Guys, feel quite stupid with this one, been staring at it for ages. What to combine three tables with the left join sql. keep getting the syntax error in Join operation. [CODE]SELECT SubmittedTeam FROM (NETT LEFT JOIN NETT ON NETT.SubmittedTeam = Team.Team) LEFT JOIN tempDate ON NETT.Date = tempDate.date … |
 | I've spent the last couple of days researching how to connect to a database server and modify the data in that server. I was able to find a lot of information on how to Read from a database, but I found very little material to assist with Writing to a … |
| | Hey Guys, I'm connecting to an SQL server and updating some fields. This works: [code=c#]cmd = new SqlCommand("UPDATE Laptops SET Checkout_Date = '" + form_CheckOut.checkout + "' WHERE name='pen-laptop1'", conn); cmd.ExecuteNonQuery(); [/code] But this one doesn't: [code=c#] cmd = new SqlCommand("UPDATE Laptops SET " + " isCheckedOut = 0" + … |
| | HI, THNX FOR HELPING IN MY LAST POST. Now i wants the help in follwing problems. i have a table in my sql named as "retailer001". i have a php page that have the data entry form of all field that are in mysql table. my table retailer001 having 11 … |
| | Hello, This is my first appearance on a forum ever, I am fairly new at programming and I have following question : If I make a INSERT...SELECT statement (to transfer data from one table to another) in a MySQL-editor, the statement gets executed once ; the same statement in my … |
| | I want to store a map that is drawn using Map info software, then store it into the database, but I have not known about spatial data in sql server I tried creating a table using geometry data type like: [CODE] use master go CREATE TABLE Districts ( DistrictId int …  |
| | hi i am trying to insert into mysql databse using jsp.but i am getting the error as [CODE]An error occured between lines: 38 and 47 in the jsp file: /jsp/havyaka/register.jsp Generated servlet error: C:\tomcat\work\localhost\examples\jsp\havyaka\register$jsp.java:102: Incompatible type for declaration. Can't convert int to java.sql.ResultSet. ResultSet rs = statement.executeUpdate("insert into havyak(usercode,password,email,name,phone,add1,add2,add3,add4,country) values('" … |
| | Hello every bdy dre......... I have developed the desktop (windows form) application using C# , with MS SQL 2005 database. That is separate application run in four different centers with their own separate database, but now i want to make it centralized database. For all four center has only one … |
| | hai all. i got a problem to display a total from a few data in my database for example, in my database i got these fields: TABLE STUFF food double; clothes double; groceries double; total double; ---> should i put this in my table to save my total that will … |
| | I have a datagrid showing my items - I want to modify a field in the database when the user clicks a button. So if row 3 is selected, I want to modify "SomeField" in Row3 to True. Is there an easy way to accomplish that? |
| | Hello, I have a web service in which i am making connection to the database to get data..now i want that the app pool account should be used to make the connection and not the current user's credentials..can somebody tell me step by step what changes do i need to … |
| | please tell me how i make a sql query for selecting data's from a table where that data repeated 4 times in that column |
| | Hi all, i started programming with .NET (i have express edition) and wanted to make a conection to an SQL Server.. the problem is that i cant conect :( previously i had .net 2005 - i started having the issue there - i unistalled it, n installed visual studio 2008. … |
| | hi,i want to know how to export sql server 2005 database to access through vb.net coding..no need to select n insert table one by one,just save package... |
| | i am using database with table RESUME and column PageIndex in it which type is number in database but when i want to store this PageIndex value to an integer i get exception error **Specified cast is not valid.** here is the code [CODE] string sql; string conString = "Provider=Microsoft.ACE.OLEDB.12.0; … |
| | hiiii friends, i have a table messages whose columns are id(primary key,auto increment) from to sub body now when i am trying to insert in the table with the following syntax insert into messages values(2,'$from','$to','$sub','$body') it is working fine. but since the id is in auto increment mode i am … |
| | hallo evryone...i have just installed sql 2005 on winxp and i was wondering how do i access remotely the server from another computer. i want to know the softwares to download for the client computer..should i also run sql server 2005....i don't know how to access the server...kindly assist |
| | I have an array that was an 'explode' from an sql query, and i want in another query, search for an field called "id" by each value of the exploded array(it can be 1 value or 17) and get the field "name" associated to the id, and so create another … |
| | Hello, I have a SQL Server DataBase and have about 10,00,000 entries to be inserted into the database before the database becomes operational. I am currently performing an insert query for each entry, as they have to be read from a file and decided into which table they should be … |
| | Is there a method for checking which roles a user has in SQL using SMO? I can add a role via: [CODE]user.AddToRole("Administrators")[/CODE] But cannot see an obvious method to progmatically list them. |
| | [COLOR="Green"]Table Name => PropDocument Column1 => propertyid ( foreign key from Property table ) Column2 => documentid ( foreign key from Document table ) The error ( in the attached image ) comes when I try to delete the record. This error comes often when there are 2 records with … |
| | Hello there, Im trying to write a query where if a query is run on a set of tables and the result of that query is null then i want it to run a different query based on different tables. i.e. [CODE]SELECT CASE WHEN (Resulting Value from this query is …  |
| | hi guys having a problem getting a single value from a mysql query getting all sorts of problems - heres my latest version below [code=php]mysql_connect($host,$user,$password) or die( "Unable to select database"); mysql_select_db("mydatabase"); // select database to use. $user = 84; $sql1="SELECT `order_id` FROM `table1` WHERE `user_id`= '$user'"; $array = mysql_fetch_array('$sql1'); … |
| | Can any body explain me[B] Adding parameters to AddParams method [/B] I cant understand the code in this code it try to delete a row from article table, for that i use SqlDataAdapter,DataSet and DataTable , //Preparing Delete Sql Command [CODE] dataAdapter.DeleteCommand=conn.CreateCommand(); dataAdapter.DeleteCommand.CommandText="DELETE FROM article WHERE artId=@artId"; AddParams(dataAdapter.DeleteCommand,"artId"); [/CODE] This … |
| | Hello, I was wondering does anyone have an idea how to make a dropdown menu that dosent repeat values from the SQL Server? Perferably using a while loop. I was thinking of camparing the set values with the new values as it loops through them but im not sure. -Thanks |
| | let output string will be, str="01/Mar/2010,02/Mar/2010,03/Mar/2010,04/Mar/2010,05/Mar/2010" Some manipulation, ******* Resultant string should be, "01/Mar/2010,02/Mar/2010<br/>03/Mar/2010,04/Mar/2010<br/>05/Mar/2010" Here I want to replace Comma (,) by <br/> Note: I want to replace even commas only. (before 03/mar/2010 & 05/Mar/2010..like) |
| | Hi, what would you recommend as the best book for someone *new* to SQL and SQL Server (specifically 2005, Developer version)? Thanks!  |
 | Hello guys. I'm building an application that connects to a SQL Server 2008 database via connection string. The thing is, since the computer loading the app (or the user, in either case) is outside the Active Directory domain, I can't use Windows Authentication to connect to the DB. But when … |
| | hi can any one please tell me how can i increase sql packet size in xampp server? i am getting an error like "Mysql packet size is 1MB and it is lower than the size of the file GeoIPCountryWhois.csv which is 9MB. " Thanks |
 | hi guys. its been a long time but sincerely, am happy to be back. now i've got a problem on my mind and that is; am trying to develop a database application but i want it to be a console application. the major issue is that i dont know how … |
 | Hi Buddies, Can anybody give me the sample to do sql connection through windows authentication through asp.net? I was tried lot of ways. but it throughs empty value for the username and access denied. Please help me to solve this issue. |
| | Hi, Everybody, I wrote the program to connect to the Microsoft Sql server 2000. I have also defined constrains and triggers on Tables of SQL. Now I want to catch the error message generated by the triggers or constraints in c prog and want to show it to user. Can … |
The End.