2,403 Solved Topics
Remove Filter  | |
| | Hi, I have page that allows the user to search using a "date range" AND "location". I'm able to do this individually. Its like, if the user searches using the date range (from begin date to end date) the results show. Then if the user searches using a specific location … |
| | G'day, I've got a table [CODE]CREATE TABLE IF NOT EXISTS `attractions` ( `attID` int(11) NOT NULL AUTO_INCREMENT, `attName` varchar(255) NOT NULL, `adultPrice` double NOT NULL, `childPrice` double NOT NULL, `referenceID` varchar(255), PRIMARY KEY (`attID`), KEY (`attName`) ) ENGINE=InnoDB;[/CODE] Now my initial set up was that [B]referenceID[/B] was linked to [B]attID[/B] … Databases mysql |
| | if not exists (select * from sysobjects where name='amrreconAccountsTB') begin execute "create amrreconAccountsTB(acct_id char(2048) NULL)" end; Message from server 'NOCTREPI04' (Msg 156, Severity 15, State 2): error near the keyword 'end'. Can someone please help me and tell me what is the syntax error here? Databases microsoft-access |
| | Hello everyone! This is my first post, been a long time reader though. First of all, it's been a while since I don't program and I'm rusty (very). The problem is: I just can't learn how to use the JOIN or UNION commands, everything I read is confusing. I'm simply … |
| | So I went to mysql docs to check out if they had info on what to do. I found this [QUOTE] “[0-9]*” matches any number of digits, and “.*” matches any number of anything.[/QUOTE] So, I tried them both out & have no result that back back. The query I … Databases mysql |
| | hi! I hope this is the place for my my question: I work on a file tagging system. I write it in java and use MySQL as my DB. I have a table that contain only one field: file's path. when directory is renamed, it's path changes. and that's mean, … |
| | Hi everyone, that's my first post in these MySQL forums :) In college they gave us a E/R in order to make it on MySQL Workbench and I'm not sure if it is OK. If you could help me it'd be great :D Because I started with MySQL just a … Databases mysql |
| | hey guys, im doing a databases project and im a little stuck this statement wont work(its part of a jdbc) and i get the following error messahe, any suggestions as to why? [CODE]stmt.executeUpdate("CREATE TABLE LOCATION (" + "serial VARCHAR(10)," + "notice TINYINT(10),"+ "intransit ENUM('T','D')," + "dtnoticeissued DATETIME," + "lat NUMERIC(8,4)," … Databases mysql |
| | Hello there, I've been having problems creating a part of my mail system that makes messages look red when they haven't been read, and white when they have been read. This is what I'm using right now [code=php]mysql_query("UPDATE Mail SET Read=1 WHERE ID={$messageID}");[/code] The SQL ID Field is a smallint … |
| | I'm having this issue displaying the results I need. The issue is that I cannot condense my results and end up with extra. The code I currently have is below. [CODE] SELECT category.*, content.* FROM `category` LEFT JOIN `content` ON category.categoryid = content.parentid WHERE category.parentid = 1 ORDER BY category.title … Databases mysql |
| | I have this very weird project that my boss gave me. Given my cws.sql file inside "C:/", i need to create a batch file wherein it will automatically create database cws; and use cws; in MySQL Server. Hope Someone can help me. :'( Databases mysql |
| | I have been given a report that is generated by running the following query from a macro ( slightly edited to simplify )and I have not had a great deal of experience with Access. The report is grouped by Data.Type and sorted be Data.Date [ICODE][COLOR="Green"] SELECT DISTINCTROW Data.Type, Data.Date, Data.Code, … Databases microsoft-access |
 | Hi all... I am a developing a website using a joomla. I need to display a content but the should filter according to the date. I need only display content which are in between current date and before 30 days. my current mysql quary is SELECT * FROM events WHERE … |
| | i have a regular expression that's supposed to match any string containing certain words in no particular order. the pattern is in PHP: [CODE]var $pattern = /^(?=.*\bword1\b)(?=.*\bword2\b)(?=.*\bword3\b).*$/gmi[/CODE] this pattern works well both in javascript and php but in SQL, it does not work. I searched and found out that some … Databases mysql |
 | Hi friends..... As when i am doing this task and found know help .............. here i am putting steps for importing data from Excel sheet into SQL Server 2003. How to Import data from excel sheet to SQL Server Note : - Sheet should be exactly same as Table in …  |
| | Hello, U just started using acces and I need to make a query using multiple tables. I read some tutorials and watched videos but I can't seem to do it right. I have 2 tables: the first one is Login, the second one is Group. Login contains Username, Name, Group … Databases mathematics microsoft-access |
| | I've designed database structure for a system I'm building. Currently I chose to use a forum style (forum, thread, post) for a section which gives user content. I'm stuck on name / naming conventions since it is not a forum. I want to use basic name principals. I thought at … Databases |
| | Hi Guys! Am revising for my upcoming exam. I was trying a question in the past papers. It read: [INDENT]A power-tool hire company requires an object-relational (e.g. Oracle) database to record details of their tools and rentals. Customer details, including their name, address and telephone number, must be recorded for … Databases oracle |
| | [CODE] SELECT Customer_Info.CustName,Customer_Info.Address,Customer_Bank_Info.CustChequeNo,Customer_Bank_Info.CustAccountNo from Customer_Info,Customer_Bank_Info WHERE Customer_Info.AgentID=Customer_Bank_Info.AgentID [/CODE] THERE ARE TWO RECRODS ARE AVAILABLE IN Customer_Info TABLE AND TWO RECORDS ARE AVAILABLE IN Customer_Bank_Info BUT WHEN ABOVE QUERY IS EXECUTED IT SHOWS 4 RECORDS IT REPEATS THE QUERY THAT'S WHY SAME RECORDS FROM THESE TABLE ARE RETRIVED FOR TWO TIMES. … Databases mysql |
| | Hy, I have a select like: [CODE] select case when isnull(my_table.entry,0) > 0 and my_table.edate = convert(datetime,substring('2009-09-20',1,10)) THEN COUNT(*) else 0 END as no_entries_date1 ,case when isnull(my_table.entry,0) > 0 and my_table.edate = convert(datetime,substring('2009-09-21',1,10)) THEN COUNT(*) else 0 END as no_entries_date2 ,case when isnull(my_table.entry,0) > 0 and my_table.edate = convert(datetime,substring('2009-09-22',1,10)) THEN … Databases mssql |
| | Hello, I am trying to structure query to execute MySQL fulltext search. I have creates simple table as follows: CREATE TABLE IF NOT EXISTS `entries` ( `id` int(3) NOT NULL auto_increment, `doc` text collate utf8_unicode_ci, PRIMARY KEY (`id`), FULLTEXT KEY `doc` (`doc`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; And … Databases mysql |
| | This is a rookie question and don't really know how to word it so that google finds me an answer, but can someone give me an example of a query using multiple WHERE restrictions so I can see how to format my query? Databases mysql |
 | Hello ... I have a very annoying problem just now, MySQL server in my office is not stable. This morning it has stopped for more than 10 times. :'( FYI, the version of MySQL is 3.23.54 running on redhad 9. When I tried to restart it, it showed like this: … Databases client-server mysql |
| | I need to keep track of the status for a person who registers for an event. This is going to be part of a tool that is administered by non-programmers. Various events will have different sets of status values, and it is possible for several events with distinct or overlapping … Databases legal web-design  |
| | [CODE]<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AdNetConnectionString %>" SelectCommand="SELECT AdCampaign.ID As [ID], AdCampaign.CampaignName FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)" DeleteCommand="DELETE FROM [AdCampaign] WHERE [ID] = @ID" > <SelectParameters> <asp:SessionParameter Name="EmailAddress" SessionField="EmailAddress" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="ID" Type="Int32" /> </DeleteParameters> </asp:SqlDataSource>[/CODE] In tge previous code. When … Databases mssql |
| | Hi, I was wondering what is the "cleanest" way of combining two datasets by taking all the values from one data set and only the values from a second data set that have an index that does not appear in the first. Both data sets have the same columns. Even … |
| | Hy, I seek your help in solving the following problem: I have a select which returns columns like ( without count_same which I need to create by counting the same name): ID | NAME | no_items | count_same ----------------------------------------------------------- 1 | A | 1 | 2 2 | A | … |
| | I am trying to access a Mysql Server through Lan using VB6 using ADODB connection db.Open "DRIVER={MySQL ODBC 5.1 Driver};DATABASE=xxxx;SERVER=192.168.1.6;USER=root;PASSWORD=xxxx;OPTION=3;" it is giving error [Mysql][ODBC 5.1 Driver]host couldn't connect to the Mysql Server My Server IP is :192.168.1.6 user is: root Firewalls are turned off.... Might be i need to … Databases mysql  |
| | Hi guys, mysql noob here. :) So here's my problem. I have 2 tables, Order(order_id,product_id) and Product(product_id,product_name). For one order, I can have many products. So my question is how can I auto increment order_id? When I insert multiple products in the order table, it generates an order_id for each … Databases mysql |
| | Hi everyone, I've been charged with creating a complex database that includes all kinds of entities with common data elements including customers, users, vendors, shops, organizations, etc.. I've worked on databases with separate tables for each primary entity like (customer table, lead table, vendor table, user table, organization table). My … Databases database-design |
| | Okay, fairly straightforward mysql insert from a form, the insert works fine but i wanted to have it check for duplicates first and kick out an error if the name already existed in the table. That said, I worked out a few errors in the jsp, and have it down … |
| | hello. i have a database with school names, their budgets and their expenses. i have to write trigger not allowing to increase expenses, but only to lower their value. if someone wants to increase it, there should be message. i know i have to remember somehow the old value and … Databases mssql |
| | Hi, i've tried several times, but haven't succed in making this: Classroom2 Name: | Date: Oliver | 12-10-10 Homer | 12-10-10 [COLOR="red"]Peter | 11-11-10[/COLOR] Classroom1 Name: | Date: James | 20-10-10 Lars | 20-10-10 [COLOR="red"]John | 11-11-10[/COLOR] How do i make a SQL statement that ONLY selects the lastest dates … |
| | I have created a table named "MapDetail" : the FIELDS identify the formname, the name of the textbox , and data to be transferred to that textbox. My form contains a map of city lots. Each of these lots contain a Textbox. My objective is to load each Textbox with … Databases microsoft-access |
| | Hi is it possible to count days between columns, something like [CODE]datediff(date_finished-date_started) as 'days'[/CODE] only datediff works just with actual dates, and I'd like to have the days number for every row counted automatically with the rsults in a new temporary column'days'; I hope it makes sense. Please could you … Databases mysql |
| | A new site that I have to work with requires me to use putty to connect to the site if I want to work remotely as opposed to logging in to their phpMyAdmin to manipulate my data.. I am unfamiliar; please read that has having no knowledge of how to … Databases mysql |
| | |
 | Dear all, I'm stucked with my XML problem. I have these stored procedures to save XML data into server hard disk. [CODE]CREATE PROCEDURE dbo.sp_XML_Employee(@Database varchar(10), @FileName Varchar(2000)) AS DECLARE @bcpCommand varchar(4000) SET @bcpCommand = 'bcp "SELECT EmployeeID, EmployeeName FROM ' + @Database + '.dbo.MasterEmployee ORDER BY EmployeeID FOR XML RAW(''Employee''), … |
| | Hi, I am trying to set up a section on a site where the results that are shown come from a table. I want to get the number of the 'current_round' then subtract 1 from it and use that value. I have looked up MySQL dev site, and assume that … Databases mysql |
| | Hi, I am trying to display some results where one column is equal to another column in a table. End goal: display all the results where the round and current round are the same number for every team in the table. the number of teams will change as the number … Databases mysql |
| | hey i have two tables in a database that i will like to join in the below code, but i cant. i can only use one table at a time. $result = mysql_query("SELECT name,price from products WHERE itemid = '$id'",$cxn) or die ("Unable to retrieve information from database"); if i … |
| | hi all I'm trying to write a procedure/function in pl sql that get the user's password, encrypting it with md5 algorithm and inserting it into the USERS table. any 1 knows how to do so? i know that md5 is not a good algorithm but i dont care cuz its …  |
| | I have a table and I want to start the select with the 20th row. How do I do this? Does conditionals work on "limit" Databases mysql |
| | Hello, I've been trying to find a way, using Oracle Express, to return more than one column but have only one column be distinct. The following will make all three columns distinct. I want only the Job_ID column to be distinct. Can this be done in Oracle? [code=sql]SELECT DISTINCT Job_ID, … Databases oracle |
| | i would really like to automate something like ... login to mysql cmd followed by creating a database following by creating tables... with one bat script here is my try: [code] mysql -u root password password; [/code] however it returned me this: [code] C:\Documents and Settings\lih>mysql -u root password root … Databases client-server mysql xml |
| | Hi, I was looking for some help with how i would go about setting up my commission table. Basically i have currently: Users Table UserID Username Password Email Clients Table: ClientId Client_UserID FirstName LastName Address PostCode Tel Email Insurance Table: InsuranceID Clients_ClientID Provider Commission DatePaid CarInsurance Table: CarInsuranceID Clients_ClientID Provider … Databases mysql  |
| | I have a strange problem when making a backup of my mysql databases. In order to do so I have a 2TB external hard disk mounted when needed under /backup. Before making the backup I stop mysql (with /etc/rc.d/mysqld stop) and use rsync to copy all the data to the … Databases mysql |
| | hi, fairly new to mysql. i have been working on a site which would have say 100 + agents. basically the agents clients are their own so i thought the best way would be to get a dedicated server and create a mysql database for each agents company. the database … Databases hard-drive mysql |
| | Hello I want to compare an inserted date against two stored dates in order to validate an entry. The date entered is being stored in a separate table from the stored dates. I am not sure how to go about this. So far I have this: [CODE]create PROCEDURE sp_GetTime @FullName … Databases mssql |
| | I'm re-designing a database that will facilitate registration at various events. One column in the event_person table describes the current status of the registrant. The forces that apply here are: - Various events may have different sets of status values - We may ship this as a framework to various … Databases database-design legal |
The End.