7,494 Archived Topics
Remove Filter  | |
| | How do you create lists in an APEX form which allow many checkbox selections? How do you store these in database? |
| | I am currently working on a report and I am trying to build a query that keeps giving me this error: `"Data type mismatch in criteria expression"` In my first query, I am calculating the difference between two dates to get a day until our ship leaves port (ex. 6/12/13 … Databases |
 | Hey guys Im doing some testing on a few database conversions from MDB format to accdb. I packged up my files so when the exe was ran it would install MS runtime as well as the databases needed for the app. I was trying to get it so that I … Databases microsoft microsoft-access |
| | |
| | HEy guys, I got possible a stupied question but i was wondering... if you are useing microsoft runtime on all of your clients computer in a office of like 150 clients. If i put a package together with MS runtime and current databases will runtime be able to to automaticlly … Databases microsoft microsoft-office |
| | Hi im trying to random showing items from data base and when echoed the same ones appear? If anyone could help that would be great. This is the query SELECT * FROM TABLE1, TABLE2 WHERE FIND_IN_SET(TABLE2.FIELD1, TABLE1.FIELD1) and `FIELDNAME` >= RAND() LIMIT 10  |
| | Hi guys, I'm trying to set a database for a shopping cart. Here is some of the code: [code] CREATE TABLE `tbl_cart` ( `ct_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT , `pd_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0', `ct_qty` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '1', … Databases mysql |
| | Importing a db table structure into a database using PHP MyAdmin the following table will not import. i can find no errors on the table, perhaps i am missing something. > > -- -------------------------------------------------------- > > > > -- > > -- Table structure for table `conversations` > > -- … Databases mysql |
 | hi, it is possible that one column in a row has a data ? and how to code it in vb6 if possible, please help example NAME: rasha bonquel Age : 20 SUbject : Math , English, Science Grades : 78, 78, 78 NAME | Age | Subject | Grade … Databases data-science mysql |
| | ## Before You Ask ## - Engage your brain! We understand that running into a problem can turn off the rational centers of the brain, but please sit back and think for a bit about your problem before running off to find help. All too often a little common sense … Databases data-structure mysql |
 | Hi All, What Wrong with my QUERY ! it show Repetition of Record in INNER Join i.e when i have 3 record in database it show it 9 time using This query.... SELECT dbo.EmployeeSetup.EmpID, dbo.EmployeeSetup.EmpName, dbo.EmployeeSetup.FatherName, dbo.EmployeePayment.Designation, dbo.EmployeePayment.Department, dbo.EmployeePayment.Salary, dbo.EmployeePayment.Advance, dbo.EmployeePayment.Deduction, dbo.EmployeePayment.OvertimeAmount, dbo.EmployeePayment.PaymentDate, dbo.EmployeePayment.ModeOfPayment, dbo.EmployeePayment.NetPay, dbo.EmployeePayment.PayMonth, dbo.EmployeePayment.Fine, dbo.EmployeePayment.Fund, dbo.EmployeePayment.Insurence, dbo.EmployeePayment.Tax, … Databases sql |
| | Hey guys, New to the site, new to writing SQL queries and have no background in this type of thing. But I've been googling my way to victory for the most part. I'm struggling on probably a very simple problem. I'd like to Sum the contents of a column, if … Databases mathematics sql |
| | hello, am new here and new to php/mysql coding. i have 2 tables - tbl_prodstd and tbl_products tbl_prodstd - std_id, prod_name, prod_desc, prod_photo, prod_brand tbl_product - prod_id, std_id, prod_name, prod_brand, prod_desc, prod_price, cat, subcat, prod_photo i created 3 pages - add_prod.php, addprod.php, func.php the func.php displays prod_name and prod_brand as … Databases html-css javascript-jquery mysql php |
| | I'm trying to set a query that will pull all clients whose birthday is today. I'm using phpmyadmin localhost via Unix socket, birthday is set as DATE. All I need returned is the firstname (emp.emp_firstname asfirst name) , lastname (emp.emp_lastname aslast name) and date of birth (emp_birthday as 'dob')  |
| | I have two tables named `stockin and stockout`. I can execute query easily separately for each table. Now, I want to bind both query in a table. Please check query and output below- query in stockin: select serialno, sum(in_quantity) SUMIN, group_concat(in_quantity) GCIN from stockin group by stockin.serialno output: +----------+-------+-------------+ | … Databases mysql |
| | Hi, I have a string formula and I wanted to execute it in sql server 2008 UDF function. Please suggest to proceed. P.S. I have tried with exec () - error occurred. Databases client-server mssql sql  |
 | I am stuck on the final part of the query, I know that this thing is easy, but I am out of ideas now, so sorry for this. I have prepared a query like this: SELECT A.projectName as PARENT, (select COUNT(*) from PSPROJECTITEM WHERE PROJECTNAME = A.PROJECTNAME) parentprojecount, B.ProjectName as … |
| | Hey guys Im doing some Research on the artical title. Im wondering if it is possible to have an Access database set upfor a company, but instead of installing microsoft office on every client machine, can you create an .EXE excutable file that will access the database that will be … Databases microsoft microsoft-access microsoft-office |
 | ## Stored Procedure ## -- Procedure name: billing_to_invoice_update BEGIN UPDATE accounts.0_debtor_trans SET ov_amount=ov_amount+fee-oldfee WHERE trans_no=encounter AND branch_code=pid; UPDATE accounts.0_debtor_trans_details SET unit_price=fee/units,quantity=units,qty_done=units WHERE debtor_trans_no=encounter AND stock_id=CONCAT(code_type,'/',code); -- gl updates UPDATE accounts.0_gl_trans SET amount=ROUND((-1)*fee) WHERE account=code_type AND memo_=CONCAT(code_type,'/',code) AND last_service_encounter=encounter; UPDATE accounts.0_gl_trans SET amount=ROUND(fee) WHERE account=1100 AND memo_=CONCAT(code_type,'/',code) AND last_service_encounter=encounter; END BEGIN … Databases mysql |
| | Hi all! I don't know if that was a good title, but; I have this query (I will call it query1): "SELECT InvID, quantity FROM Recipe WHERE MenuID = 1" In my tables, this will give me something like Water(20), Oil(30) Now, from this result of a SELECT query1 (i.e … Databases mysql |
| |  |
 | Hi All, This is something I should know but for whatever reason today it is eluding my mind. I'm trying to query our database to provide me with data between March 2012 and March 2013. Initially, I had the following line: where a.IPI_Ref_Date between '2012' and GETDATE() and the output … Databases mssql |
| | Need some help here. I was trying to make a Stored Procedure in MS SQL 2008 which will make use of comma delimited string as Parameter in my WHERE [COLUMN] LIKE [PARAMETER] condition. Somehow, I was able to select rows of data from my DB table that matches the set … |
 | Dear All ! I have a table member_email. i have 4 columns in it. Id Email CellNumber Carrier I want to create constraint who check following conditions, 1-Email can be null if Cellnumber is given , and Cellnumber can be null if email is given. 2-both email and cell number … |
| | I came up with this query now when i tried to create a view it failed to create SELECT aDate FROM ( SELECT @maxDate - INTERVAL (a.a+(10*b.a)+(100*c.a)+(1000*d.a)) DAY aDate FROM (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 … |
 | Group, I may have made a huge mistake repairing SQL Server Management 2008 Express. Here are the details: I'm running Windows 7 on a Toshiba Laptop. SQL Manager 2008 had been installed and was working fine. I had some registry errors popping up, so I ran ARO 2013 to do … Databases sql |
| | Hi i am new to ms access databases, really struggling with my tables relationships my database has more than one many-to-many relationships, for example one instructor can have many classes, one class can have different instructors, one client could have different instuctors, one instructor could have many clients and all … Databases |
| | I have the following simple table: CustomerID CustomerName NumOfOrders 1 Joe 15 2 Jane 20 7 Clara 1 I want to find the customer with maximum number of orders. Seems trivial enough but I can,t seem to find a solution. Databases mysql |
| | Hi I'm a newbie in SQL and for scores whose credit is greater than 2, I want to select students with scores of 10 or more .Here is what I wrote and Im having errors(See table below): SELECT Student,COUNT(Score)>=10 AS NumPasses WHERE Credit>2 GROUP BY Student Student Credit Score Tomy …  |
 | Hello DBAs, Can any one guide me how can i get the last modified date(insert/update/delete) of a table? Regards, B. Mantri Databases oracle |
| | All, I am somewhat confused by the way modern dbms handle timestamps. It seems as though date and time can be together in one field yet still be queried as if they were in different fields. Say I wanted to do a SELECT where time is between 1AM and 2AM. … Databases |
| | All, I'm trying to decide if I should use an auto-increment field or GUID field in a database. Either way I get a unique number identifying the record, so I'm not sure what way is best. Any thoughts? Thanks, -Bill Databases |
| | Hi All, With SSIS, upon load, I am receiving the following error: > Error 1 Error loading DownloadCSVPackage.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. C:\Projects\EconAnalysisStatsCan\EconAnalysisStatsCan\DownloadCSVPackage.dtsx 1 1 I have gone through all of my connections … |
 | Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'some_user'@'abcd.efgh.com' (using password: YES) in /home/some_dir/public_html/some_dir/db.php on line 1 Fatal Error: MySql connection failed.Access denied for user 'some_user'@'abcd.efgh.com' (using password: YES) Here is my code of db.php <?php $connect = mysql_connect('www.example.com','some_user','some_password'); if(!$connect) die('Fatal Error: MySql connection failed.' . mysql_error()); $connect_db = mysql_select_db('db_name'); if(!$connect_db) … |
 | Hi! Ok, here's my problem... Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'hjhwkhjrf'@'10.1.1.43' (using password: YES) in /home/a6653219/public_html/connect.php on line 12 (pw changed) Lower part of connect.php..... $=line 12 // do not edit below this line!! /////////////////////////////////////////////////////////////////////// $dblink=MYSQL_CONNECT($MySqlHostname, $MySqlUsername, $MySqlPassword) or die("Could not connect to database"); @mysql_select_db("$MySqlDatabase") or die( "Could … Databases mysql  |
| | Hi all I have an sql output query problem I am trying to resolve. The problem is that I have centres that offer Awards and quals and some centres only offer awards or quals only. What I need to process is the centres that offer both awards and quals. tbl.net.qualification … |
| | Hello, I'm trying to make notification when msql column reach a certain number. For exemple, I have table "items" with products, witch in their structure have columns id, name and quantity, and when column "quantity" reached 5, I want to make automatic notification: - In new table called "notifications" witch … Databases mysql  |
| | HI! Just setting up my site... first thing I see after domain working is..... Fatal error: Call to undefined function session_is_registered() in /home/vhosts/www.universal-abundance.com/config.php on line 87 Any ideas..... I'm db impaired! Thanks, L-D Databases mysql |
| | This is my SP code SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE SP_Get_Age @name varchar(20) AS BEGIN SET NOCOUNT ON; SELECT Age FROM PersonDetails WHERE Name1 = @name; END GO This is my C# code private void callSP(string name1)//name1 comes properly in button click event { using … Databases mssql |
| | Hello, I have a table called product and whenever the value of the field stock = 0 I want to send a notification email to a specific email address. I would like your help guys on how I can implement that and if this is possible. I considered using PHP … |
 | I'm trying to generate a random number for each field in column "A" of my spreadsheet, and I have been trying to experiment with the following formula: =LARGE(ROW($1:$1000)*NOT(COUNTIF($A$1:A4, ROW($1:$1000))), RANDBETWEEN(1,1000-ROW(A4))) This is giving me the numerical values that I want, but is affecting both Columns "B" and "C" as well. … Databases microsoft-office |
| | Hi, I typed the below code in oracle 10g express edition. [CODE]SELECT emp_id, last_name, salary, dept_id FROM employees WHERE emp_id = &employee_num [/CODE] I get an error; ORA-01008: not all variables bound Can you pls help? Thanks. Databases oracle |
 | The program can run , but after i insert the user detail and go to refresh the dataTable i get this error msg "This database cannot be imported " Imports System.Data Imports System.Data.SqlClient Public Class frmMain Dim con As SqlConnection Dim cmd As SqlCommand Dim adapter As SqlDataAdapter Private Sub … Databases dataset open-source visual-studio |
| | Hello Guys, During the process of making my website I have been stopped by a problem. Background Info: I am using jQuery sortable lists and I have multiple lists on the site which submit the information to the file that updates them in the database. Problem: If I want to … Databases mysql |
| | I am completely new to database design, and have been given the following scenario. I have spent hours trying to work out how to draw an ERD for this scenario but am no closer to working it out. Does anyone have any advice for where i could start? I think … Databases database-design |
 | Hi All, I am running the following query: UPDATE YFR_Master_Fundraisers SET FRActive=0 WHERE FRNameCode IN ( SELECT FundRaiser FROM YFR_Master GROUP BY FundRaiser HAVING MAX(CollectionDate) < DATE_SUB(CURDATE(),INTERVAL 2 MONTH) ) It is giving the error described in the subject line. The query seems to be taking too long and timing … Databases mysql |
| | I want to build a voucher system. I am developing an application and want users to login from a database (preferable MS SQL). I want the DB to randomly create codes for users to top up their accounts. The codes will be unique in that they will be based on … Databases mssql |
| | I think this is probably too ambitious, but I though I'd ask anyway. I have a list of about 13 000 music venues, including their name and location, but would like to add phone no., website, and email to that information. To do this manually would take a long time, … Databases mysql |
| | I'm not sure if this is the right place to ask , but is this erd valid? Or is it unacceptable? Thank you for any help. Databases oracle |
| | Hi Experts, Which database is better acc to Performance factor. Need Suggestions.. |
The End.