2,569 Topics
 | |
| | 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 … |
| | 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 … |
 | 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 … |
| | 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 … |
| | 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 …  |
| | 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 …  |
 | 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 … |
| | 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 … |
| | 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 … |
| | [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Data.Sql; using System.Data.SqlClient; using System.Configuration; using System.Linq; using System.Text; using System.Windows.Forms; namespace Eventmanagement { public partial class Registration : Form { SqlConnection aConnection; string firstname= string.Empty; string lastname= string.Empty; int aid; string date = DateTime.Now.ToShortDateString(); SqlDataAdapter da = new … |
| | Hey all, I have split an Access database not on the server. I have decided to VBA code the links, however I have reached a stall when attempted to VBA code the update query; updating the remote table with data from the local temporary table. I have tried multiple things … |
| | I've setup the ability for members to select their favorite games. I probably could have built this better from a database design point of view so I'm open to suggestions there. Aside from that I'm trying to build a query that provides me with counts of the games so I … |
| | I have this page that you can do a search on the site. However, if I do a search that contains an apostrophe ('), it breaks and doesn't display anything although I have entries that have them. Does an easy fix exist for this problem? This is an example of … |
| | The application is currently developed using ASP.NET (C#) I have code to pull data from a SQL Server 2008 table and organize it into an hierarchy: [code=sql] With hierarchy (id, [location id], name, depth, trail) As ( -- selects the "root" level items. Select ID, [LocationID], Name, 1 As depth, … |
| | I find for just numbers type_digit() works great combined with addslashes() but what about for a mixture, to prevent SQL injection?  |
| | Hello, i am facing an issue in retrieving data from an array. I have a table called registered_members, the table contain First_name, and Last_name. I also have a table called Friends, it contain Friend_ID, Member_ID, Status. What i did is that in a search box, when someone type a name …  |
| | Hi all, Sorry for the long post but i need to describe my problem properly to avoid confusion, i hope I have a table with users, and every user has a specific latitude and longitude coordinate. let say user Test_User is logged in and then he decides he wants to … |
| | I was just wondering if it can or not. Otherwise wouldn't this code work great for stopping SQL injection? [code=php] $some_post = addslashes($_POST['some_post']); if (!ctype_alnum($some_post)) { //error } else { //all good } [/code] |
 | Hello, I have a query, that I am trying to have a conditional statement for a variable that I will pass into the query. If I use one of the conditions it works, but if I try both I can't get it to work. I would appreciate any help. Thanks, … |
| | Dear all i have created a from to receive data from users. and data will store in sql table. all is going well. BUT NOW i have installed a module so users can type in Hindi fonts to fill details in form. when users will type data in hindi font … |
| | Hi I'm not an asp .net developer although I have done web development with php and mysql, I'm more of a software developer for desktop and mobile devices. So this is my first big project with ASP .NET. I have a question with the ASPNETDB database, understand that the database … |
| | Dear knowledgeable ones A new problem have arisen. I have now an SQL database file with about 100 tables in it. I would like to automatically go through all of these tables and check if the column "Owner" exist. If this field does not exist, then it should be created … |
 | [B]is Codeigniter able to protect Your Site From sql injection When You Use Active Record??[/B]  |
| | hi i have a question in reporting server. the server is started and when i try to go to the URL it doesn't give me anything my windows account does not have admin privileges is this the cause for this. and from MS SQL management studio when i try to … |
| | hi there, i am using a code to back (downloaded) up a database in a server and when i run the application it gives me an error saying operating system error 3 [CODE=C#] //Use this line if you have already created a bakup file. File.Delete(DBpath + "\\backup.bak"); this.Cursor = Cursors.WaitCursor; … |
| | Hi all, First-time poster and netadmin/infosec guy trying to get into coding. My company uses a SQL Server 2005 database to store customer information and the like, and I'm hoping to learn to interact with it programmatically so I can write and/or customize software to make life a bit easier … |
| | hi there, i have a question in connecting to the server. when i log in to the server and connect to the ms sql server i can connect to the databases. but when i login to another computer and try to login to the MS SQL server management studio i … |
| | This question is more specific than general. I understand SQL a good amount, and understand JOINs and UNIONs etc, but I am having a real problem with a query I need. I have three tables: [CODE] ITEM: ITEM_ID ITEM_NAME WISH: ITEM_ID CUST_ID SELL: ITEM_ID CUST_ID [/CODE] What I need from … |
| | Hello everyone, I am using [CODE]ExecuteNonQuery()[/CODE] to execute a SQL command that inserts data into a SQL Server 2005 Database. I want to return the number of rows affected. I've read that this method returns the value, but I can't figure out how to access it. Help is very much …  |
| | Hi. I'm having a problem on deleting a record using a function on SQL. DELETE FROM tblServices GROUP BY ServiceID HAVING MID(ServiceID,1,2)='SG' This query shows and error saying: Cannot group on fields selected with '*'. I tried adding a specific field, like this: DELETE ServiceID FROM tblServices GROUP BY ServiceID … |
 | afternoon all hope someone can help, i want to populate a report and print it directly without the user hitting the print button. i have this working in a diffrent project but for some reason it wont work in this one. i get the error missing parameter, on the last … |
| | i wanna enter a value passed by javascript function to the database. is there a way to do that? thanks. var eng = 0; var nothome = 0; var nointerest = 0; var callback = 0; var booked = 0; function myFunction(i,txt, elemid){ var plural; if (i != 1) plural … |
 | hi I want to fetch data from sql and use them to make a new data I really like to store the records in variables and maybe do some operations on some of them , but the main point is to update three tables in ways that are not the … |
| | hi there, i was doing some changes to the ms sql reporting server and after some time i get an error saying "the request failed or the service did not respond in a timely fashion. consult the event log or other applicable error log for details" i restarted the server … |
| | Hi all, This is ridiculous they teach so much at uni except what you need to know to program :-/ haha. This is actually gonna be a 2 part question but I'll do it one at a time. So I'm developing a small program for a company, this company has … |
| | eu preciso de puchar somente um valor de uma tabela do sql, que eu estarei usando este valor para definir os usuários as roles, irá funcionar assim, o usuario loga, então é criada uma conexção no banco de dados e nesta conexão ele verifica em qual role este usuario esta … |
| | Hi, I got a crystal report with:- main report subreport(Item_A) subreport(Item_B) There is a limit for the subreport to show only 5 record, if there is more then 5 records it should go to a new page. I have been trying to do this for 1 week, i tried so … |
| | HI all, am fairly new here stil and hope to give back as much as i take , in time , experience and wisdom... (the wisdom bit is probably way off for now) I have a set of tables , but one table needs to show the information chosen in … |
| | Hello friends. :(I have a problem but i don't know how to implement a solution. The problem is that the HDD's from two Windows Servers got corrupted [COLOR="red"](1.- Site Server, 2.- File Server)[/COLOR] and all the files PDF's and the main site(ASP) were unaccesible for a while, now i recovered …  |
| | I return 30 tables or so from sql in a stored procedure. In the stored procedure I select these tables via... [CODE]select * from myTable1 select * from myTable2 select * from myTable3[/CODE] etc. These tables lose their sql table name when returned in a dataset and have default names … |
| | Looking for an answer about how I can use relations in my DB, when a link is clicked. I have the main navigation in the top of the page, the table is called:"SUBJECTS", primary key is ID. I also have a local navigation in the left side of the page. … |
| | This is old college assignment am doing to sharpen my sql skills, its cat test centre and this funtion is checking if the mechanic is available on certain date which is input from user in the anonymous block. the problem i m having durning testing is that the function result … |
| | I am getting the value of a datetime picker and add it in the database but it is throwing an exception saying : [COLOR="Red"]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime. The statement has been terminated.[/COLOR] This is my SQL Statement … |
 | Hi Everyone, I have this problem. I am done with the coding, and I want to access it using a url. The program is working perfectly in my local computer, but when I try to go to IIS, add a new website, assign port, like what I did in my … |
| | I am creating a cms, where I have a Global horizontal navigation(SUBJECTS) in the top, and a local navigation(PAGES) on the left, all database driven. First I decide if either a subject or a page has been set, to display the correct information: [CODE] if (isset($_GET['sid'])) { $subjectid = ($_GET['sid']); … |
| | Hi everyone, I am new to this board. I am trying to figure out how to set up an SQL statement to grab a record from a database when I'm not sure what column/field the string I am looking for will be in. for instance: I am looking for "ABCDEFG", …  |
| | I keep getting the following error when I try to add new record into database (Access 2007) "The INSERT INTO statement contain unknown field name:'login'." I dont whats wrong as the coding looks fine and the field login does exist in the database. Spent whole day trying to find the … |
| | Hi all, I have had a look around the forums but i could find anything, if someone could point me in the right direction for this. What is the best way to handle an sql connection, in my program I have to get data from the server on a button …  |
| | I am designing a website that connects to a database. I am using wampserver to connect to the website. In my customer add page I am trying to ask the website to generate an autonumber from the database. As my table in the database is set up as following: [CODE=SQL]CREATE … |
| | Hi guys, I'm trying to build a query that involves two tables, the course table and the studentsLink table. The StudentsLink table describes the link between students and the course. The tables are as below; Course courseID(bigint) - PK courseName (varchar) courseInstructor (varchar) StudentsLink courseID(bigint) - PK StudentID(bigint) - PK … |
The End.