2,569 Topics
 | |
| | Hello, I have a 4 GB DB on SQL 2005 and the same on on sql 2008 that is growing 60MB per day, My concern is that should i allocate an unused space to the DB so that the DB wont create space for itself everyday (load on the server), …  |
| | I'm trying this: [CODE]$recordset = $conexao->Execute("select * from PRO where CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd(\"d\", +15, NOW()");[/CODE] PRO_DTCAD is REGISTER DATA PRO_DURAC is DAYS TO EXPIRE But: [QUOTE]PHP Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> Missing ), ], or Item in query expression 'CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd("d", +15, … |
| | Hello I have tow queries on my website. A first query that extracts a number of records from my "Tutors" database based on the criteria "Location". This query works fine and returns "Id", "Name" and "HourlyRate". I want my user to be able to see an extended profile for each … |
 | Hi everyone. Can someone please recommend a SQL editor (other than SQL Developer) that will allow me to test out my SQL statements & queries outside of the DB environment. I will predominantly be working in a windows environment, but may move to a linux environment at times. Will be … |
| | I am using MS ACCESS, and have 4 tables to update, from 2 different tables/spreadsheet Where table tb1- Client Index, Name, address and zip. tb2- user index, Sales rep, client index tb3- user index, Managers tb4- client index, Sales Target Master 1 has Name, address, Sales target and sales rep … |
| | I am trying to read data from remote SQL base. I have written the function that works great if you need to get 1 Value , but when I want to read 2 or more value at from one query it doesn't work how can I fix it? [CODE]Imports System.Data.SqlClient … |
| | I am trying to produce a query using a java server page which will go through all the elements in an arraylist to see if there are any matches, can anyone help? Thanks  |
| | Are there different SQL extensions? What are the extensions for Data Mining and Warehousing? |
| | In my database I have a field date and eventname.I want to retieive eventnames after the current date.How can I do it? |
 | I get the following message when executing a stored procedure. [COLOR="Red"]The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.[/COLOR] However , i cannot change the fact that the SP uses … |
| | Is this the right place to ask the following? I have 2 tables in two different MS Access DB's. Access allows the ability of inserting data from DBA.table1 into DBB.table1, using the format [dba].[table1].[dbb].[table1]. Here's my problem. Using a single SQL Statement I can't figure out the following. DBA.table1 has … |
| | I need a way of adding data to a database using my delphi form i can handle the sql to add data to a database on ms access but i just do not know how to do it through a delphi form. In other word i just need to know … |
| | Hi guys, I have created a site where users can upload videos(mp4) and images(jpg & gif). The upload script sends the uploaded file to a folder on a remote server, and the filepath is stored in MYSQL. Can any one tell how i go about playing the stored videos or …  |
| | Hi, I am trying to create a search function on an html page. I have written the page and part of a php page. I trying to get help with the search as there are 3 criteria; So far I have made this search form; (textbox name=searchterm) [B]Brand[/B]: (dropdown name=type) … |
| | Hello, I want to create database on SQL Server using Javascript and HTML. User will input following data. Server Name, Database name, File Sizes. When I will click "Submit" button database should be created on Selected server with entered name. I am using Client side HTML and Javascript. we need … |
| | 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 … |
| | how to insert system current date by using sql query in SQL SERVER 2005 |
| | 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 … |
| | 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 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 … |
| | 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 … |
 | [CODE]Sub QryReport() On Error Resume Next Dim QryDef As QueryDef Dim str As String Set QryDef = dbase.QueryDefs("balancesheet") dbase.QueryDefs.Refresh If Err.Number = 3265 Then Set QryDef = dbase.CreateQueryDef("balancesheet") dbase.QueryDefs.Refresh End If str = "select * from [balancesheet]" & _ " where Date ='" & Dtpicker.Value & "'" QryDef.SQL = str … |
| | I have an arraylist in which i have stored structures. Now i store the arraylist in a session and pass the it to the nextpage. I am having trouble trying to figure out how to get the strusture values out of the arraylist and store in database.....???? Anyone who knows … |
| | With the release of [url=http://esd.ingres.com/] Ingres Database 9.3[/url] today, the company says it's now easier for developers to migrate their application to the open source system from MySQL, Oracle,SQL Server and Sybase. It does so, the company said, through "improved accessibility of table procedures from within the query" and support … |
| | After all the next next work, i reach the Install button and when i click on install it says "TITLE: Microsoft SQL Server 2005 Setup ------------------------------ Could not find a package to install on the installation media." How to solve this problem.. |
| | I am, as you can assume from my login that I am a SQL DBA. I have been programming since 1994 and still loving it. I came to this site as I was looking for an answer to a C# question. I didn't find it but was impressed with what …  |
| | Hello everyone - first time poster here, long time reader. I have a minor issue that appear to simple to fix - but I've just hit a road block. I would like to create a three way inner join to display all the information I need in one SQL statement. …  |
The End.