2,569 Topics
 | |
| | 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 … |
The End.