2,570 Topics

Member Avatar for
Member Avatar for aspkiddy

Hi, I have some difficulty with my 'select' In my select/menu, I display all the options come from a table (table_db_email) in my database In this table ([B]tb_code_prmtn11_email[/B]) I have two field : [B]fld_email_id fld_name_email[/B] It works here is a code [CODE]<select name="email_adress_menu" id="email_adress_menu" class="valid" onchange="submit()"> <?php echo "<option selected=\"selected\" …

0
101
Member Avatar for whin_lopez

Hi im new to sql server 2005 and i have a big problem. i want to delete a record having the same name and surname Here is my table named Students StudID FirstName LastName 1 Erwin Lopez 2 Archie Lopez 3 Lobanz Lopez 4 Erwin Lopez 5 Chie Lopez 6 …

Member Avatar for BitBlt
0
187
Member Avatar for vishalrane

I am getting this error when i try to connect to the server... Hot to rectify it... "This version of Microsoft SQL server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)

Member Avatar for Netcode
0
111
Member Avatar for rad@rad45.org

Hello Group, I'm running with MS XP Professional, version 2002, service pack 3. Many of you may well have already heard that there are some problems being encountered by some users with trying to install the update for SQL S/Pack 3. KB970892. As I do a lot of traveling with …

Member Avatar for Susan In Aus
-1
305
Member Avatar for zepi

hi all, please help me on this... Is there a way to get the SQl View's String Command used to create said View? For Example, I have a View named tryView, now I want to get the string command used to create tryView like this one... [QUOTE] CREATE VIEW tryView …

Member Avatar for adam_k
0
113
Member Avatar for feedz87

- I'm using ms sql and then i export the database and then i save that export DB at desktop.After that i delete the database in ms sql because i want to learn how to import the DB.My problem is cannot import the DB that i export before.Anyone can help …

Member Avatar for BitBlt
0
200
Member Avatar for neosonic

Hi all, I need your help. I have an insert query which insert a few rows into the table A. TableA has two primary keys, which are fieldA and fieldB. The SQL is written as follows: INSERT INTO TableA (fieldA , fieldB, fieldC, fieldD) SELECT DISTINCTROW TableB.fieldA, TableB.fieldB, TableB.fieldC, TableB.fieldD …

Member Avatar for neosonic
0
189
Member Avatar for ndeniche

Hi guys. I know this is a long shot, but does anyone know if parallel computing (multiple simultaneous programmers/developers working on the same file) is possible for SQL databases? What I'm wondering if is possible is working on a local database that updates the mdf file in two computers, which …

Member Avatar for BitBlt
0
251
Member Avatar for whodoes21

Hello :D we've been working on this simple student database where we can add, edit and delete a student record... sooo going straight to the point I'm having problem with displaying details from two different tables as you can see we can only open using one connection string and try …

Member Avatar for whodoes21
0
206
Member Avatar for avinashmalla

I have written some sql codes in a file named sql.sql and I want to install my database using this file. How can I do it? Please help me out.... here is the sql code from the file sql.sql [CODE] CREATE DATABASE IF NOT EXISTS wm; USE wm; CREATE TABLE …

Member Avatar for sanchin
0
838
Member Avatar for Lapixx

Hi, Although I'm not really a novice when talking about web development, I'm not really used to writing MySQL queries that are a bit more advanced than the absolute basic SELECT/INSERT/UPDATE/DELETE queries. Anyway, currently I started working on a project that shows relevant items to the user: A 'you might …

Member Avatar for smantscheff
0
190
Member Avatar for drewpark88

Hey Guys, I have an "events" table in my DB and a "default_events" table also. Every day I display one event. I check to see if any rows in the "events" table match todays date and then display that event, if no events match by date, I check the "default_events" …

Member Avatar for drewpark88
1
116
Member Avatar for santhoshvkumar

Hi all, I am trying a scenario for calling a shell script when ever a trigger is called. Can some one guide me how to achive this scenario. Also it should passes the value from the table to the shell script. Can some one explain me along with the example. …

Member Avatar for JeoSaurus
0
84
Member Avatar for legend_89757

i want try to update the value of record from table1 where the value i need is from table2 like: table1 [CODE]Item_id | Quantity 0001 | 100 0002 | 200 0003 | 300[/CODE] [CODE]table2 Item_id | Quantity 0002 | 100 0003 | 50[/CODE] [CODE]when the query run.... i want the …

Member Avatar for crishlay
0
136
Member Avatar for sels2005j

In my application some stored procedures are not working properly in current database of SQL Server. I have taken backup of database 2 weeks ago and all stored procedures are working in backup database. I have checked the properties of current database and backup database both are same. After restoring …

Member Avatar for crishlay
0
160
Member Avatar for sagive

Hey guys.. could someone please help me with.. What wrong with this: [CODE] echo "<td width='25%'><img src='images/Lock.png' title='" . $row['username'] . "' - '" . $row['password'] . "'></td>";[/CODE] i Get only the username.. Cheers, Sagive

Member Avatar for sagive
0
92
Member Avatar for NuGG

I have made the mistake of adding a large amount of comma separated data to a specific field in a certain table without adding spaces between each! (Stupidly didn’t realise the associated application requires spaces!) Now I am trying to create a query that can add these spaces in automatically …

Member Avatar for ChrisPadgham
0
364
Member Avatar for solvesak

The code given below is showing error: Error: 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 'group,type) SELECT ex_tax.username,ex_tax.exp_id,exp' at line 1 [CODE]$sql="INSERT INTO ex_cat (username,exp_id,used_category,group,type) SELECT ex_tax.username,ex_tax.exp_id,ex_tax.category,ex_tax.group,ex_tax.type FROM ex_tax WHERE ex_tax.username='$uname' AND …

Member Avatar for solvesak
0
100
Member Avatar for c++_fem

Hi, Does anyone know how too solve this: I want to delete a row from database and I keep getting this error: [B]The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses, except when these data types are used with the LIKE …

Member Avatar for zmeditation1
0
138
Member Avatar for jeevanism

The case scenario is like I have to check all available usernames/names from the databases whenever I type the letters instanly. For example:- When type "je" in the userfield, it should show all combination of names starting with "je" inline. I am attaching a picture as sample. Its indian railway …

Member Avatar for urtrivedi
0
202
Member Avatar for danholding

hi i have a drop down list where i select an employee id, once i click the button i want it to populate the Rate text box with the rate which matches the id from the table in sql. i have this so far but not sure if i have …

Member Avatar for danholding
0
215
Member Avatar for sourav_kings

Hi experts, I am trying to figure out code working for an auto testing as follows: (in C# code, SQL database used) 1. Check whether database (having credentials) is working fine or down? 2. If working, run a select query in it & check for succesful execution. 3. In any …

Member Avatar for jfarrugia
0
145
Member Avatar for sim08u

Hi guys i have an assignment and it's asking me to let the user enter data into one of three text boxes to search for something in a database it also has to show the results in a table and be hyperlinked to the next page being bookingdetail.php and the …

Member Avatar for urtrivedi
0
830
Member Avatar for dwayned

Hi I am trying to update my database based on the selected values in two comboboxes. Combobox1 = Manufacturers Combobox2 = Orderlists In the App the user selects a manufacturer and then an orderlist and then presses Ok button which updates the default orderlist for the manufacturer. I am having …

Member Avatar for InsitizrT
0
2K
Member Avatar for blackrusader

Basically, it is an open source software creation application that revolves around databases (similar to Microsoft Visual studio in some aspects but with python as the language). The user will be able to create forms with a drag and drop GUI builder, create an SQLite database and add functionality to …

Member Avatar for blackrusader
2
322
Member Avatar for tjfitz68

Hello, List below is a query that I need to somehow be able to modify so my results do not double the tblWorkOrder.iWorkOrderID rows. The reason it's happening is because the INNER join for the tblTechnician causes it to double the iWorkOrderID's when there are two or more technicians that …

Member Avatar for BitBlt
0
114
Member Avatar for neoseeker191

I'm getting an "Object reference not set to an instance of an object" error with this line of code: [code] t1.FindNode(rs.GetString(4)).ChildNodes.Add(node); [/code] Here is all of the code: [code] using System; using System.Data; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration; using System.Data.SqlClient; namespace TreeViewProject { public partial …

Member Avatar for abelLazm
0
205
Member Avatar for drewpark88

Hey Guys, I need some assistance if possible. I am using MySQL & PHP, I have an "events" table with a row field called "Users_Attending" and can't seem to figure out the best way to add multiple users to an event rows "Users_Attending" field. I want to store user emails …

Member Avatar for drewpark88
0
143
Member Avatar for Avrajit

Hi, I am unable to run my c# application on a different computer other than my own computer. I have an attached mdf database file in my project. I have 'SQL SERVER 2008' as pre-requisite in the setup project. The application is installing & running fine on my machine, but …

Member Avatar for Avrajit
0
639
Member Avatar for music613

I need to tackle the question of threading in Visual C# application development. In its most basic use, I will need to "branch out" to SQL SPs (for example), but need to be able to inform the user that "I'm doing something" - such as the following outline: 1- user …

Member Avatar for abelLazm
0
304

The End.