1,694 Topics
| |
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 … | |
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 = … | |
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... ![ecb53783b16f2f19f927a3cd72bee4d0](/attachments/large/4/ecb53783b16f2f19f927a3cd72bee4d0.png "ecb53783b16f2f19f927a3cd72bee4d0") 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 … | |
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. … | |
I have a form that has two parameters amenities and attributes. The amenities parameter has a dropdown menu that whose value gets populated from a separate table. The second parameter is attribute whose value will be entered by the user and will get saved in a database. View of database … | |
Hi there! I have a problem and i want you guys to help me. I have 1 table which has many fields. (mysql and im connected from microsoft visual studio..runs very well so there no problem with this). lets forget the fields that we dont want now.. i have 4 … | |
I have an Access Database on which I have tables with similar structure and columns name columnA and columnB.I can use the below query on tables created design time to get this output. Table | result -------|-------- SELECT "Table1" AS Table, SUM(a) - SUM(b) AS Result FROM table1 UNION SELECT … | |
I'm trying to create a store procedure in mysql and it is giving me errors and I don't know why since the sql code works just find. Here is the sql code: CREATE TEMPORARY TABLE IF NOT EXISTS table2 AS ( select AVG(Score) as AVG, MovieCode from UserMovies group by … | |
Hello everyone, I am putting together a project where people are able to upload multiple choice questions to a larger database and then create tests from them. I have several questions (and I apologize for the length of this post) about what is the best way to go about doing … | |
| Try DoInsertQuery("If Not Exists(" & _ "SELECT * FROM tblSchoolYear " & _ "WHERE schoolYear = 'SY " & Trim(txtAddSchoolFrom.Text) & "-" & Trim(txtAddSchoolTo.Text) & "')" & _ "INSERT into [tblSchoolYear] ([schoolYear]) VALUES ('SY " & Trim(txtAddSchoolFrom.Text) & "-" & Trim(txtAddSchoolTo.Text) & "')") Catch ex As Exception MsgBox(ex.Message) End Try … |
I'll prelude this with I am a novice coder at best and this is mostly a hobby that I would like to do professionally one day, but that day may be 10+ years from now. So for now I tinker and learn here and there. Part of the reason I … | |
I'm using MS SQL 2012 - trying to LEFT JOIN 3 Pivots - but am running into issues within a query variable that I'm not sure how to debug. Each Pivot works on it's own - but the actual Joining is causing the issue. Any help is appreciated. First time … | |
the relation betwwen student and course entity is many to many.but it is not recommended .how can we convert it to two one to many relationships? | |
This the following code for member_account.php in the member_profile.php there is a link for member_account.php, after I login then i can see all information and in the headbar it shows username,account logout home link. but whenever i click to account I can see only logout and home link (i made … | |
Hi guys i have an sql query string that in my view there is something wrong with it but i an handicaped since i am very new to sql so my question is, is there any way of optimizing this query string select t1.cat,t1.site from (select cat,site from news where … | |
The End.