6,934 Topics
 | |
| | i am using SSRS 2005. In my dataset there are some blank rows and in SSRS is showing blank rows. Is there a way that i just show rows with data and ignore blank rows. i set the visibility property but it is showing blank line. dataset: a b c … |
| | Hi, I have an app that gets data out of the database. This data is updated via a separate application. At the moment the first application has to check every x seconds if there is any new data. I seem to remember reading a while ago something about subscribing to … |
| | Hi All, If anyone can help me take my sql database (a single table) that information and display it in a form on my web page. Sometimes the Sql request will be multiple lines of the table. I have my database created am completely lost in the form view or … |
| | how to insert system current date by using sql query in SQL SERVER 2005 |
| | Hi. I have a web application whereby I perform a search through 4 fields, namely:book serial no.,tel no.,gender and publishing date.In my jsp page variables picking the values respectively are:serial,tel,gender and datez.These are submitted to the java class.Currently, I perform my searches as follows(in java class): /***********************************************/ [code=Java]//......after connecting to … |
| | Hi to all, May I ask any help for a code in VB6 in saving images in either SQL server or MS Access databases? Please give me some idea thanks a lot in advance. |
| | conectivity of sql & visual basic is needed as early as possible pleaseeeeeeeeeeeeeeeeeeeeeeeeeeeee!  |
| | Hi, I hope someone can help me creating a sql for the purpose i have. I have a table named case_score_t with these columns: id, case_id, user_id, score, created_date I am interested in picking the rows with the greatest created_date, for a certain user_id. I now this SQL with give … |
 | Windows Server 2003 Standard Edition Service Pack 2 SQL Server 2005 Standard VS 2008 Hi everyone. I'm currently working on the following tutorial: [url]http://www.asp.net/Learn/Security/tutorial-04-cs.aspx[/url], but I get an error adding a SQL Server DB to the App_Data folder. I right click App_Data, click Add New Item, SQL Server Database I … |
| | hi, how the way backup database in sql server 2000 with syntax sql for one month, i mean query. Thank's |
| | JSP is a new world for me, since 3 days ago. I am having a problem (or I have no idea) how does the inserting datas into database works. I have looked at some examples, but still, im having a hard time. I know PHP and ASP, but JSP is …  |
| | Hello Everyone, I am implementing an asp.net web site. I use sql membership provider. Some times when I am trying to connect with my database, It gives an error message "Login failed for user 'operator' ". Here operator is the account that I am using to connect Sql server using … |
| | I think my thread title is a bit incomplete. coz these are my questions.I need answers to these questions for the completion of my thesis. [B]I Know this is sort of a long message but im detailing the situation for better understanding of my questions.[/B] And because these thread is … |
| | Hi everyone, I sat down to create a what I thought was simple SQL query but once I got thinking about it I realised I'm not sure where to start. The objective is to return two resorts from a Resorts table for each country code in that table. Countries table … |
| | Hi, I am doing a student progression system where the application is able to keep track of student marks. I have a problem currently and I've been spending nights on this. Let me briefly explain. Marks are calculated based on their hurdles. So for instance, H1 = xx%, H2 = … |
| | i m final year student of computer engineering and there is problem for me in my final year project. i want to attach databases to sql server dbms from one of the form of my vb.net application. the idea is that a want to have a button name "Browse" when … |
| | all I need to do is have a control that a user keys in a code that is validated against the sql table and brings back the associated web page for that code. does anyone know how to do this in Visual Studio 2003 |
| | Hello, Ihope to find some help in here, i have the following diagram [URL=http://img143.imageshack.us/i/13503390.jpg/][IMG]http://img143.imageshack.us/img143/6704/13503390.th.jpg[/IMG][/URL] and i want a query which return Emp_ID, Pro_ID note; i can get these values but by 2 queries as the following; [code=sql]select Pro_ID from Projects where Dep_ID in (select Dep_ID from Departments where name = … |
| | hi, Im calling Oracle 10g stored proc from python 2.6. 1. How do I pass String VArray (list in python) to stored proc ? 2. How do I return cursor from Oracle stored proc ? 3. How do I return list of strings from Oracle stored proc ? My Oracle … |
| | Hi, I'm trying to move "leftover" data from one database table to another after the user clicked on a button. Please can anyone give me some advise. This is kinda really urgent plz. Everytime i run my app it gives no error but also doesn't move my data. :angry: I'm … |
| | |
| | I have an assignment that states >Research on Microsoft SQL Server, Oracle, and MySQL. Briefly describe each database application. What are their inherent benefits or limitations? Assume a pro or con approach: Based on your research, which would be the most reasonable approach to this solution and why> All i … |
| | Hello Everyone. I want to make query with php combo box items. When the user click on the items of combo box, the following table will generate correspondent data. Now i can display data in one table, but i don't know how to use it with combo box. Does there … |
| | Hi all well this is the first time in this forum so I'll be clear about my question and thanks in advance I'll create a software in C#, this app takes a cvs file (about 73,000 lines). This files comes from another system, also the cvs file can change, what's … |
| | |
| | Hi Guys My hosting company confirmed that recently it appeared that somebody was trying to hack into my website. I was able to confirm the page used but not whether they actually got through - no data in the database was changed. I have never come across this before and … |
| | Hi Community! I have already searched the whole web about this Problem, and I didn't find anything. Maybe you can help... I want to show the number of all SQL queries I executed to load a web page. It is a very complex system I programmed, and I don't want … |
| | |
 | Hi I developed report using sql server reporting service.I used parameter to assign value for sql query.I want to use "LIKE" keyword in using parameter,How i do that?i wrote coding below what u wrote before.I used @con as parameter. [COde=sql]Select FriutID from Friut where friutName like'@con'%.[/COde] Once I write above … |
| | Hello everybody, Hope everyone is fine over here. Well .. actually, i am developing a networking application, or a client-server application where many clients on a LAN will connect to the server. Actually I am a bit confused with the database part, one of the features of my application is … |
| | Hi, I just came across a piece of script that has been put into my source code throughout the site...and not by me. Im not sure how they did it but im fearing this could get more serious and end up them hitting my db. Here is example(kind of) of … |
| | I’m going to demonstrate a very short and simple method of avoiding SQL Injection at the SQL query level. You’ll need MySQLi support, on Debian you can apt-get install php5-mysql will contain everything that you need, and would be installed by default with your LAMP Installation. Calling: [url]http://www.mynonexistentdomain.com/test.php?user_id=10&record_number=1[/url] Ignoring any … |
| | I am a new SQL user and I have created my code but when I execute it I get this error : [COLOR="Red"]Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Job_Title' in the database.[/COLOR] I do not understand why I keep getting this same … |
| | [B]I am trying to prepare a report detailing all jobs entered into program sorted by customer and then by project name. Also produce a report for total products for all projects in database.[/B] I am able to create diferent classess (Component) for all my formular product calculations and then reference … |
| | Hi, i have created a sp, that is taking too much time (more than 35 sec, is it more?). [Code] SELECT top 11 ROW_NUMBER() OVER (ORDER BY hjs_job_details.date_posted desc, KEY_TBL.RANK desc) AS Row, job_id, (case when len(job_title)>59 then (substring(job_title,0,59)+'...') else job_title end ) as title, company_name as Source_Org, source_company_name as … |
| | Hi, Im new in C#, could you help with my codes. I need to connect to MS SQL DB (2000) and need to call Stored Proc to return value. Here is my codes: [CODE][COLOR="Green"]private void ExecuteStoredProcs() { SqlConnection conn = new SqlConnection(connectionString); try { conn.Open(); SqlCommand getRequestCmd = new SqlCommand(SP, …  |
| | I am just new in C#, somebody can you give me code for MS SQL server connection, on how to call records, add, edit and delete records...THANK YOU |
| | Hi I am trying to insert data into a sql server database table using sqlDataAdapter and adding newrow method.But the values entered are not saved in the database.What I did is............ [CODE] string sql = "Select * from Users"; dataCmd.CommandText = sql; SqlDataAdapter da = new SqlDataAdapter(dataCmd); da.SelectCommand = new … |
| | [code=sql]"SELECT tbl1.staff_ic, tbl1.staff_name, tbl2.dec_status,tbl4.location, tbl3.post,tbl3.grade FROM staff_detail tbl1 INNER JOIN staff_declare tbl2 ON tbl1.staff_ic = tbl2.staff_ic INNER JOIN staff_post tbl3 ON tbl1.staff_post = tbl3.num INNER JOIN staff_department tbl4 ON tbl1.staff_dep = tbl4.no ";[/code] isn`t my coding is right?? why when i execute my command just certain data are appear and … |
| | I am new at oracle and working on a small project. I am trying to find "[" in a field and produce from that point to the end of the field. My code is as follows: [code] declare startPos PLS_Integer; endPos PLS_Integer; begin set startPos := (Select top 1(instr(description, '[', …  |
| | I need to know how and what steps to automate to backup a database on my production SQL server and restore that database in my test SQL server. The database exists in both servers currently. I want to set this up so it will run every day at a certain … |
| | Hi all, I'm a newbie in sql, please can someone help me out in constructing a query. What I want to achieve is to have filter/search menu with a list of the different options/optionsvalues that applies to a particular category of products and a count of the products that possess …  |
| | Hi. I'm using php and mysql for a system. I have some questions on INSERT query. When we are using INSERT, in our query.... i. Is it necessary to include each field included in the table we are going to insert value with (though some of the field maybe do … |
| | Hi, I have searched for ages trying to find a solution for this but I cannot. I'm still learning asp.net so apologies if this is a noobish question, but could somebody please look at my code and tell me what's wrong? I have a small cms that uses fckeditor to … |
| | hi daniweb... i need some help for my projects...maybe u all can help me.... i want to make a autonumber field in sqlserver and will be reset to 1 every 1st day in a new month....it will be use for document numbering..because i want to make the doc format is …  |
| | Hi all, Is it possible to insert a SQL statement where I specify the time, and not the date. I do need the date, but I want it to be the current date when I run the insert statement. The time got to be fixed. For example, Insert into xxx …  |
| | hi guys!!!!!!!!!!!!! This is my first thread and i want a little help. Currently i m working in a project and my project is to replicate (copy one way only) records from a db40 database to a MYSQL database. Information will only be inserted into the db4o database. There will … |
| | I'm using this piece of code to get the number of search results. However it says- Incorrect syntax near ')' (the very last ')' ) [CODE] SELECT COUNT(*) FROM (SELECT ID, ProductDescription FROM Products WHERE ProductDescription LIKE '%tech%') [/CODE] The inner select works fine and gives correct results, so I … |
| | Greetings! I am hoping someone can help me with a MS SQL query/view problem. I am creating a "name my new baby" website where parents can upload a picture of their child and have users cast votes for a good name. Users will see the child's photo and they will … |
 | Hi all, I have a Subscription database running and i am trying to insert values into it from an ASP web form when i click on a button with an id of 'confirm'. The name of the field is 'startdate' (date data type) and i need to enter today's date … |
The End.