2,569 Topics
 | |
| | Hi I need to look in a field to find the text same as another field I have this at the moment but it does not work, hoep you can help update TAB1, TAB2 set `field3` =`field4` where FIND_IN_SET('`FIELD1`', '`FIELD2`') I feel FIND_IN_SET is not the right thing as the … |
 | Does anyone know this error : Syntax error (missing operator) in query expression '***Budy Soleman***' **<--( this is content of textbox.text)** This is my code in VB.net with ms-access Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Call connect() Dim simpan As String simpan = "insert … |
 | Hi, I want to output a simple result. I join 2 tables and SUM one column in one, i get the SUM results correct but cannot get the num_rows proper. My Code: $clientid = 24; $query = "SELECT items.itemid, SUM(prices.priceid) as PR FROM items JOIN prices ON items.itemid = prices.itemid …  |
 | Hi guys Im trying to save a combobox selected item to my database but i cant get it working, it saves "user" instead of the username that is stored in the combobox, any suggestions? here's a snippett Try '----------------Sends the message------------------------------------------------------------------- MysqlConn.Open() ' opening the connection to the DB Dim … |
| | I have the following view: ALTER VIEW [dbo].[vw_RelInclusaoGeralCivil] AS SELECT DISTINCT m.Nome AS MunicipioNome, au.Nome UsuarioNome, s.TipoId AS SolicitacaoTipoId FROM Solicitacao s INNER JOIN Unidade u ON s.UnidadeEntregaId = u.Id INNER JOIN Endereco e ON u.EnderecoId = e.Id INNER JOIN [IBGE.Municipio] m ON e.CodMunicipio = m.CodMunicipio INNER JOIN Terminal t … |
 | I worked on a program a few years ago that takes data from a series of text files and loads an Access database. I added to the code from a program started by someone else, so I did not write the imports and declarations. They used an ADODB.recordset, addnew and … |
| | Hi, I have a filestream enabled DB and a table to store the files. Until now i used to get the path of the file that has to be saved to DB. But due to some changes this was changed and now i get a byte array. my question here … |
 | Hi, I originally created this query to get a result from a single select statement Its funny that it became a very long query having sets of joined table Its also maybe annoying to look for it so im trying to trim it down most of it have same joined … |
 | Hello guys i have a big problem over here and and wierd i think, when im trying to add some info into database it works well i have 32 input fields (16 for matches and 16 for match tips) and when i will enter in each some info for ex. … |
 | Hi everybody. I'm using python to create sql database. I created a test.db file and then made a table on it with the name "fims" and inserted some data on it.... title text, year text and director text. And then set values for them. Now when i type "sqlite3 test.db" …  |
| | I have a little problem over here this code doesn't work well what is the problem if anyone know ? $getUsername = getUserData('Username'); $sql = "INSERT INTO `kladilnica` VALUES ('', '".$getUsername."', '".$betAmouth."', '".$gain."', '".$date."', '".$match1."', '".$match2."', '".$match3."', '".$match4."', '".$match5."', '".$match6."', '".$match7."', '".$match8."', '".$match9."', '".$match10."', '".$match11."', '".$match12."', '".$match13."', '".$match14."', '".$match15."', '".$match16."', …  |
| | Hello i have this code and something isn't working but i dont know what, the code it does not updating the database at all and i don't get any errors. <?php if(isset($_POST['howMuch']) && isset($_POST['where'])) { $howMuch = $_POST['howMuch']; $where = $_POST['where']; if(!empty($howMuch) && !empty($where)) { $user_mBalance = getUserData('payCheck'); if($howMuch > … |
| | I am trying to come up with a query to track a student cohort based on their start term. I want to see if the number of students that started in 2012 actually go down in 4 years time. For this example I am starting with fall 2012 (12/FA). I … |
| | Hi Guys, Im a bit puzzled on the best way to store data which will later be saved to a csv. I am doing a record search on a database table which will get cycle through each employee and get the relevent information. Once I have done this I will …  |
| | Ok so i have been trying and trying to solve this issue, but to no avail. Therefore, i am posting here. Please note that i am a self learner and don't really know things in depth, just trying to learn.. So please be gentle. Here is my aspx code: <div … |
| | Unable to execute the sql query, only dispaying blank page. <?php require('fpdf.php'); $today=date('d_m_Y'); $hostname = "localhost"; $database = "developer"; $username = "root"; $password = ""; $conn = mysql_connect($hostname, $username, $password) or die(mysql_error()); mysql_select_db($database, $conn); class PDF_result extends FPDF { function __construct ($orientation = 'P', $unit = 'pt', $format = 'Letter', …  |
 | I have problems with the enable/disable of textboxes if the radio button is selected/deselected. Normally, if I select "Others" from the radio button group "Project List", the textbox is enabled. But if I select other than "Others", the textbox is not disabled. This also happens on the radio button groups … |
 | what is the best way to save data from multiple checkboxes ?? if i have 50 , 60 checkboxes Is it reasonable to set up a column of 50 or 60 checkboxes for ٍsaving value for each question separately ? and presumably there are questions that have not responded what …  |
| | In my Windows Forms c# project I try to connect to an already existing ms sql database file (added binding Source on the form, then : bindingSource -> properties -> DataSource -> add source - > .... ) but when I pick this file it writes something like "You dont … |
| | I have the following table User in my database Name(Varchar) DateOfBirth(datetime) Age(int) Name(Varchar) | DateOfBirth(datetime) | Age(int) John | 2014-12-20 23:59:59 | 0 Mary | 2014-12-20 23:59:59 | 1 How can i verify throught javascript if the field DateOfBirth of the table User of the database z is of type … |
 | Hey all, so i am working on database queries. Add and delete are working fine. I am having trouble with Edit Query. This is what i am getting: Incorrect syntax near 'Name'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace … |
 | Hello, I need a little help with trigger, I have been doing database development for a long time now but this is my first go around at a trigger. It is not working, can someone please look at this and let me know what I am doing wrong: ALTER TRIGGER …  |
| | There are a lot of examples demonstrating how to connect to ms sql database from windows form application using Visual Studio Professional (right-clicking on the project name -> "Add" ->"new item" -> "LocalDatabase" -> give a name with .sdf extension to the newly created database - > and so on … |
| | I am trying to do a check to see if a student meets the prerequisite before they can register for a course section. CourseSecID = 27 (ID of the course section the student wants to register for.) What I am doing is querying the student's acad cred records to see … |
 | Hello all, zoidmaster here. I have a question regarding work with a MS Access database. I have the code written out from a tutorial I found online for a basic database, however all it can do with the database is read, add and delete lines from it. I'm trying to … |
| | Dear experts I am running one mysql query which contains selection from multiple tables.The problem is sometimes the query runs very slow, but sometimes it is ok.Acctually when i run it first time it is very very slow, and from the next time it becomes fast.I wonder if it is … |
| | Hi, Im trying to extract data from sql server where conditions are multiple and variying I have a datagridview with 2 columns ID and Name I need to create Select Query to extract data where condition is 'ID should be equal to the value or values in Datagridview ID Column. … |
 | I want to disallow certain query strings with robots.txt and I want to check I am doing this correctly... I am using: Disallow: /browse.asp?cat=*-* I want to check that this rule will allow these urls to be indexed: *browse.asp?cat=123/1234/1234-1 browse.asp?cat=123/1234-1* While disallowing these urls: *browse.asp?cat=1234-1 browse.asp?cat=1234-2* Will this rule work? … |
| | Hi! I would like to send SMS messages from Sharepoint when a server goes down. I have found this website that explains how to integrate it with this Ozeki NG SMS gateway. The software is ok when trying to connect the JDBC with my database, and this whole configuration looks …  |
 | I need to know how the primary index is classified as a sparse index? The sparse index as described by some aticles and books has index entries for only some of the search values and has a fewer entries than the number of records in the file. When you make … |
| | I'm implement if else in stored procedure with and oprator . If both Conditions are true the if statement should return 1 else -1. here username and email should not be duplicate please review query below. alter proc spUserdetailss @name Nvarchar(50), @passwords Nvarchar(100), @emailadd Nvarchar(50), @Gender nvarchar(50) as begin declare … |
 | I need to make my website responsive with iPhone 5s in media query. I try every thing but can't able to solve the solution for iPhone 5s in media query. Plz check the URL http://foodhub.pk/ Any one can please help me. |
 | Im new to PHP, i just want to know if theres any rule in php in terms of single statement multiple lines. for example in VB.Net we uses "&_"(w/o the quote) to tell vb.net that it is a single statment and it has a continuation. is there any in php? …  |
| | This function I have created to return all recorded Stock numbers in the Table "ContributorDeeds" the table contains only the start number of the stocks and the end number of the stocks (e.g, from number - to number) I need to get all the numbers between within that range. The … |
| | hello friends I have two tables with column A and column B. I want to update column B of table2 with column B of table1 . I have trying this query in ms access from Vb.net. update table1 t1 LEFT JOIN table2 t2 on t1.a = t2.a SET t2.b = …  |
| | I have a multicolumn listview. There are three button Add, delete and Updata. List is working fine, it add, delete and update list data. But i want to save every row inside listview when i click save button. Bellow is my XAML. <TextBox Canvas.Left="12" Canvas.Top="12" Height="23" Name="textBox1" Width="120" TextChanged="textBox1_TextChanged" KeyDown="textBox1_KeyDown" … |
| | What is meant by the bold part of the below paragraph An index is a copy of select columns of data from a table that **can be searched very efficiently that also includes a low-level disk block address** or direct link to the complete row of data it was copied … |
 | You may be wondering what a superfecta actually is, and the answer is: the most dangerous and serious threat to business. To clarify, the superfecta as defined by secure cloud hosting outfit FireHost is a group of four attack vectors that comprises of Cross-Site Request Forgery (CSRF), Cross-Site Scripting (XSS), … |
| | I have this query as part of a stored procedure, and this query as it is listed here works: INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=G:\KF\GBSData.xls;', 'SELECT * FROM [Sheet1$]') SELECT * FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE invoiceNumber IN ( SELECT invoiceNumber FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE stockNumberShipped LIKE 'CCCOMBO%' ) I would like to change … |
| | I worked for 20 years in hardware and twenty odd now in software, so change is an old friend. I consult on UNIX/LINUX to a variety of industries, write lots of bits for my own needs, love to help others over their hurdles.  |
| | Hey good people, I hope you are all well. Ok so here is the scenario, i have 4 tables that i have made in sql server 2008. I am using a drop down menu to diplay their names. Like this...  I am going to use a dataGrid view. … |
 | Hi guys, I'm currently on the pretty cool Database development path. I've quickly got to terms with basic SQL with individual tables, and various queries. Now things seen to be getting a little beyond a concept I had been taught from a young age. Am I doing this right. The … |
 | Ok, what I'm trying to do is have next and prev buttons to navigate through a mysql database sorted by date. Currently, the code I wrote does this, but gets stuck on duplicate dates. $Next = mysql_query("SELECT * FROM $logbook WHERE Date>='$Date' AND ID!='$ID' ORDER BY Date LIMIT 1"); $Prev … |
| | Here is a simple way to insert into a database that isn't much harder than using string concatenation - which we all know is very dangerous due to SQL injection attacks. Put the code snippet into `database.php`. Now, in a script handling a form post, such as `post_reply.php`: <?php require_once("database.php"); … |
| | Hey there Im tring to insert to a database from a form , however I cant get it to insrt with the dropdwon list, any help would be loved <h1>Insert Data Into Database Using CodeIgniter</h1> <?php echo form_label('lecturer_id:'); ?> <?php echo form_error('dname'); ?> <?php echo form_input(array('id' => 'dname', 'name' => … |
| | hello everyone, I am having some difficulty setting up a connection to my database. I created one on godaddy but am unable to get past this one hump: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)' in /home/badinvestor/public_html/config/connection.php:9 Stack trace: #0 … |
| | Hi, I had a little problem in querying something. When defining a project you use work items. And a work item may use a material, labor and equipment. It may not use one or two of them for that work item when it is defined. So for that work item …  |
| | Hello All, I am facing a problem coming up with a SQL query for a certain issue: Table 1 ------------------- Client ID|Name of Client|Customer Type|Account Type| 01| A | AB | 30 | 02| B | AB | 30 | 03| C | CD | 30 | 04| D | … |
| | A Drupal security advisory, [SA-CORE-2014-005](https://www.drupal.org/SA-CORE-2014-005), rather embarrassingly states that: > Drupal 7 includes a database abstraction API to ensure that queries executed against the database are sanitized to prevent SQL injection attacks. A vulnerability in this API allows an attacker to send specially crafted requests resulting in arbitrary SQL execution. … |
 | A question for VB.NET - Access DB folks here, although some might consider a strictly DB question. Is there an order of operation when a SQL query 'does its' thing' relating to the 'WHERE" clause with multiple parameters? In other words, could you rearrange the elements [filters] of the WHERE … |
The End.