6,934 Topics
 | |
| | Hi, I'm writing a C++ script and part of it is to connect to an SQL Server. C++ is new to me so I'm still working my way around. Any help would be greatly appreciated. Many Thanks  |
| | how can i use to show the selected value from data set i think there is a problem of dataset use to take out value from data set my code is [code] protected void Page_Load(object sender, EventArgs e) { SqlDataAdapter adap = new SqlDataAdapter("SP_selectallbooks", con); adap.SelectCommand.CommandType = CommandType.StoredProcedure; //DataSet ds … |
| | This is probably obvious to someone who is familiar with Oracle, however, I'm writing a script file for a class, and it throws an error on the line [CODE]ALTER TABLE FACULTY ADD CONSTRAINT FACULTY_Locid_fk REFERENCES LOCATION;[/CODE] where the table is FACULTY, the column is Locid, and I'm trying to create …  |
| | The following code is a part of my project and the output of this code is that i get all the title of the posts in the database and a delete hyperlink in front of all enteries now when i click delete for a respective title it should be deleted …  |
| | Hello all. I am in the process of piecing together a software project that I plan to use in the day-to-day operation of my service business. I'm sure this will be a simple question for someone here. I will be tracking employees, service tickets, clients, & client IT Assets. I …  |
 | Hi Experts: When i run this page on my online website with mysql (already with Oracle), this errors orrurs. Exception Details: System.Data.OleDb.OleDbException: [1]: 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 'exec print_pack.check_print … |
| | Dear All i need help how to insert data into sql database form a datagrid... this is the example.... i have view data from tabel sales in a data grid product name sales jan sales feb sales mar MILK 10 15 20 Biscuit 7 6 9 Tea 5 15 30 … |
| | We use a single database in SQL Server 2005 and the size is around 190 GB. We plan to spilt the database in following methods; 1. single instance multiple database without synonyms 2. single instance multiple database with synonyms 3. multiple instance multiple database Need inputs on the below queries: …  |
 | I'm having a strange problem with a website I'm working on. What I want to do is pass a SQL query variable (in this case cid) using a link, but for some reason it just isn't working. This type of query works just fine on other pages of this site, … |
| | Hey, I am very new to php. I have a PHP script (modified from [url]http://woogley.net/misc/Highscore/)that[/url] I call from a my Java code to access a database in order to read/write records. The SELECT part of it was perfect. However, i can't write to the database when I try to UPDATE. … |
| | Hi Everyone, Can anyone pls help me out......with my requirement, i am struggling since 3 days. Please find the requirement below my file contains below data Code: R1|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|SURFACE MOUNT|AND|8533.10.00.20|8533.10.00.20| R1|Array/Network Resistor - VIP|V_RES_NW_CLASS|V_TECHNOLOGY|CARBON*||8533.10.00.20|8533.10.00.20| R4|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|THROUGH HOLE MOUNT|AND|8533.10.00.57|8533.10.00.57| R4|Array/Network Resistor - VIP|V_RES_NW_CLASS|V_TECHNOLOGY|CARBON*||8533.10.00.57|8533.10.00.57| R7|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|SURFACE …  |
 | hey... i'm using Visual Studio 2010(c#) for a winapp i'm writing. i have a DataBase in which i have 6 tables and there are so many fields in them that use unicode characters( Persian) and all of them are nvarchar(n) type cuz i had problem with text earlier, but when …  |
| | I can't find a tutorial anywhere on how to search a sql database using a textbox and a button in asp.net any help. I'm coding in C# Sql database has a customers table I want to display firstname and lastname by searching cust_no |
 | This script will display a previous next script that will look like this: << prev 1 2 [b]3[/b] 4 5 next >> It is clean, and avoids large numbers of pages in the prev/next links [code=php] $server = "localhost"; $user = "username"; $pass = "password"; $databasename = "yourDBname"; $db = … |
| | hi. I'm working with php-oracle and I need to do a query that I know will return a unique string, but when I execute the query all that I recieve is a number. Why? this is my code: [CODE] $nombre=oci_parse($conexion, "select nombre_cliente from cliente where cod_cliente=$codigo_de_cliente"); $nombre_de_cliente=oci_execute($nombre); [/CODE] nombre_cliente is … |
| | I have a webpage that builds an html table if there is any data in a mySQL table. That works fine, the html table is populated with data from the mySQL table. My problem is when there is data it populates the html table but lists the first mySQL table … |
| | Hi how would I go about creating a payment schedule based on a date and a number of months 3 or 6 or 12 to then populate the database with reoccurring dates so lets say new user added on 31/10/2011 for 6 months I need the database to add all … |
| | Hi all, Im starting to program in java with sql. The problem im having is that when im trying to complete a combo box with data from a table in sql i get this error: [U]"null error in cargarComboProvincias()"[/U] when i run the program, and i cant find the error … |
| | Having problems with the TypeError below: [code]order_list = ['25459 ', '12381 ', '25375 '] cursor.execute("SELECT WVGID6 , WVWHID, WVITNO, WVLOCA FROM WMRSV WHERE OHORNO IN (%s)"% tuple(order_list)) TypeError: not all arguments converted during string formatting[/code] The correct SQL should look like: [CODE]SELECT WVGID6 , WVWHID, WVITNO, WVLOCA FROM WMRSV WHERE … |
 | |
| | OK, I have a table that has: id (int), name (varchar), parent (int) If parent contains NULL it IS the "parent" otherwise it is the child of a parent So: id=1 name=Meals parent=0 Means the above record is a "parent" (there are 100's of parents). So far, so good? Next … |
 | HI, In my crystal report i want to use the SQL expression field to calculate the opening balance of the account based on the date passed to crystal report using parameter field.. How can i do it?? Thanks & Regards, Victoryy |
| | Hi All I want to create a service application with Delphi that can connect to SQL DataBase I can create service application but the ADOQuery don't work inside the service Is any one that can tel me what should I Do? Thanks |
| | hello all, i got project on online examination i want to fetch data dynamically from database. it must be like that once student loged in. he must gives answer for 1st Q. to go next Q. when they click on any of the buttons. next Q. must be fetch dynamically … |
| | Hi, can anyone guide me in the right direction with the following: I want to start a hosting reseller service, didnt find a relative category to post in but my question is related to php so... I want to develop a site where users can query available domain names, the … |
| | Hi all, pretty new to sql. have made code already for showing, adding and deleting data from database but can't seem to make the update work. any help is much appreciated. here's what I have: [CODE]<html><body><form action="update.php" method="post"> <label>Person ID:<br></label> <input type="text" name="personID" size="40" value="" maxlength="150" /> <label>Customer Name:<br></label> <input … |
| | I have a table called [COLOR="Red"]school[/COLOR] and a table called [COLOR="red"]students[/COLOR]. I have a foreign key in [COLOR="red"]students[/COLOR] called [COLOR="Green"]school_id[/COLOR] which is connected with table [COLOR="Red"]school[/COLOR] , field [COLOR="Green"]id[/COLOR]. I made a form where field **[COLOR="green"]title[/COLOR]** appears to the registration form of the [COLOR="Red"]student[/COLOR]. The problem is that i want …  |
| | I can't seem to get my register page working with a password. This is the query I executed: [CODE]CREATE TABLE dbUsers ( id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, username VARCHAR(16) unique, password CHAR(16), email VARCHAR(25) );[/CODE] It only registers if there is no password filled.. |
| | Hello, like before, I'm still trying to make a register page with login and logout. Here's the link to my server (If I'm not allowed to share links please remind me.) [url]http://fifarulez.dyndns.org/hacks4all.wapzan.com/registration/[/url] After the registration it will give 2 warnings. ( ! ) Warning: mysql_query() [function.mysql-query]: Access denied for user … |
| | what;s wrong with this mysql trigger logically?? [CODE] DELIMITER | CREATE TRIGGER comment_count AFTER INSERT ON comments FOR EACH ROW BEGIN UPDATE sub_sections as t1 SET t1.published_comment_count = (select count(id) as cnt from comments where article_id=t1.id and published=0 and status=0) WHERE id= (select article_id from comments order by date_modified desc …  |
| | Hello, I've always liked coding and lately I've learned a little but more of it. Now I also understand sql and db a little more. My problem is that my register.php file seems to give me a notice. Notice: Undefined index: op in C:\wamp\www\hacks4all.wapzan.com\registration\register.php on line 11 and Notice: Undefined …  |
| | Hello, I am currenrtly trying to write a query in Microsoft Access 2010. This query retreives a list of values from a table I have called tblTable Some of the values are numeric and some are alpha numeric. I am trying to do the query so that when it comes … |
| | Pls help me with this... [CODE] //FINANCE.PHP <form id="frmpay" name="frmpay" method="POST" action="finance_payment.php"> <input type="radio" name="seltour[]" value="<?php echo $tour_code; ?>"> <input type="submit" value="input" name="submit" /> </form> [/CODE] once submitted.. [CODE] //FINANCE_PAYMENT.PHP if(isset($_POST['submit'])) { for($i=0;$i<$numrow;$i++){ $code = [B]$_POST['seltour'][/B][$i]; $query = "SELECT tour_amount, tour_name FROM `tbl_tour_profile` WHERE tour_code = '[B]$code[/B]'"; $result = mysql_query($query); …  |
 | Sir I want to connect sql server database as a public in asp.net C# i'm connected sql server in Web.Config file but i don't know how to use as a public in full project help me sir |
| | hey how to answer to these questions Table: Sales(CustomerID , RepID , Area , SaleDate , ProductNo , Quantity , UnitPrice , ItemTotalPrice) a)considering the above table write a function to calculate the IemTotalPrice as ItemTotalPrice=Quantity*UnitPrice b)Write a SQL statement to create the above table (you must use the above … |
| | Have 2 tables - one for new titles and the other for authors. I want to tag the "new titles" table with the "author" value if the author's name appears in list of new titles. As you can see from my code, I don't have a clue what is wrong …  |
| | One slippy mistake that can occur with searching Text and Numeric field is that you have to carefully add the ( ' ) character enclosing the text searching string. For example : Text search: [CODE=sql]SELECT * FROM users_log WHERE user_name='Phillip'[/CODE] Numeric search: [CODE=sql]SELECT * FROM users_log WHERE user_age=>16[/CODE] In case … |
| | I was developing a 'Payment Tracker' web application. I used MS Access as back-end database. I made a 'Payment_entry' table with user_ID and Payment_amount fields with 'Text' and 'Long integer' datatypes. Now , when I wanted to find the total payment of each user I used the following SQL command … |
| | I am not really sure where my syntax error is. I have gone over it several times and it appears everything is right and I dont think I am using any reserved words. Any help would be greatly appreciated. Every box is TEXT in access for now even fields that … |
 | I have this code for mysql, and in my table i have date entries in my date field from my date table ....i want to make use with between clause ...below is my sql statement..but it displays nothing even there are dates in between... SELECT * FROM date WHERE date … |
| | Hello My task is to write a procedure which has to get information about price of a product and updates the data base for produc_id=777. if product_pirce < 400 then product_price=500 if product_price > 400 then product_price=300 IN PL/SQL: [CODE] create or replace procedure change_price is begin if (select price … |
| | my form have more than one submit button and i want a particular sql query to execute when a particular submit button is clicked.im using jsp to code and mysql database.can anyone pls guide me.  |
| | there a form which has two text box one for name and other for age and a table containing 20 records of names and ages i want whenever form load the first value of name in table should automatically come in textbox and when we enter age and save it … |
| | So I have a database that stores when someone leaves and when they return to. dayleft dayreturned I need to do a query and also an cfif to see if a date selected is between these dates. test - selected date the Here is my long if [CODE] <cfif (datecompare(vactrue.dayreturned, … |
| | How do i change the name of a table in my sql server 2005 express edition database using visual studio server explorer? |
| | I would be grateful if someone could suggest what I need to do to get this to work. I have copied two short scripts which should demo the use of $_session, but the read script does not work. I believe the save script is the culprit though. Here they are: … |
| | Right now the company I work for is using Microsoft enterprise library very extensively. From what I've found online recently, these database objects aren't intended for web (asp) usage, and are relatively bloated. I don't know how accurate my research is, but I do know we have optimization problems in … |
| | Im checked my sql, its working fine. But im still getting this error: [COLOR="Red"]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in..[/COLOR] [CODE] $sql = "SELECT date FROM tbl_tour_profile"; $result = mysql_query($sql); confirm_query($result); // this is the die function of sql $i=0; while($date_set = mysql_fetch_array($result)) { }[/CODE] |
| | Hi I have [B]Windows 7 Home Premium SP-1, 64-bit[/B] version on my PC. I want to install SQL Server either 2oo5 or 2008. but i am unable to install this. Error: [I]OS Incompatibility[/I] Pls Reply: Thank U |
| | I have an application that I'm trying to finish in VBA, and as I've never written in it, it's a bit challenging to me. I've written some in VB but the syntax isn't the same between the two for some things. Essentially, here's the logic (or lack of) that I'm … |
The End.