2,569 Topics

Member Avatar for
Member Avatar for Venus_1

Hi! Just want to ask if it's possible that within a select statement, there has a loop. Have this sample query but when I run this it says missing expression after <column2> Select <column1>, <column2>, FOR Lcntr IN 1..12 LOOP CASE WHEN Lcntr THEN .... END END LOOP; FROM <table> …

Member Avatar for mcglk
0
159
Member Avatar for UK-1991

Hello, Created a query for getting users list excluding the logged in user well I thought about creating a simple one but huh that didn't worked for me. Okay so what logic and for what did I created for. I tried to show the users that are friends with each …

Member Avatar for UK-1991
0
430
Member Avatar for hwoarang69

I need some help with creating a simple search engine for website. Basic idea is that user will enter a string in search bar, which will compare in database key_word and get the reuslts. Lets say I have the following table on sql server database. |----|----------|----------------------| | ID | URL …

Member Avatar for pritaeas
0
1K
Member Avatar for A1990

Hi All, I have a problem when trying to change user account password in my project I am using Visual Studio 2013 and SQL Server 2012. This is the code I am using and I don't know to how to adjust it to check for the old password before changing …

Member Avatar for Santanu.Das
0
175
Member Avatar for tashiDuks

Hi EveryOne, I have a following controls in my vb.net form: txtID txtName btnAddNew btnSave This form will be storing a values to the SQL Database (SQL Server 2005). In the txtID textbox the auto id should be generated when ever user clicks on btnAddNew. The ID should be generated …

Member Avatar for Syed Hassan Abbas
0
2K
Member Avatar for skitters

some how mysql database in wamp server 2 got replaced by older database and i am unable to restore the database to the location (before being replaced by old data) from the latest backup i have . is there any way i can restore the data to my required position. …

Member Avatar for ewansmith
0
560
Member Avatar for nosfa

Hi. I have to do a MVC project and I don't know exactly how to do it. on the clientside I will have an input form the data (at least two codes and up to 8) will be sent to the server (best way?) then the server will access a …

Member Avatar for nosfa
0
335
Member Avatar for yaginuk

Hi, i bought a framework website which i am altering for a client and i am trying to add a new feature to it. i have added new field to mysql table i have added lines of code to show up on form, the choice in new feature will be …

Member Avatar for yaginuk
0
185
Member Avatar for laguardian

Hello guys. I'm trying to create a registration form that takes in employee information. The error I'm getting is: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 I'm …

Member Avatar for jwenting
0
2K
Member Avatar for zachattack05

Good afternoon fine DaniWeb folks! I am about to pull my hair out on this one and I'd like to know if someone knows of a simple or obvious "gotcha!" for this problem. I've got a form with some detail fields on it (below) ![editor.PNG](/attachments/large/2/61f8ecd049dad3f28df2d6d98b522b69.PNG "align-center") When a user attempts …

0
166
Member Avatar for Christopher2009

I am currently developing a CMS for my firm using .NET Framework ,ASP.Net(C#) & SQL Server Express 2008 ADV. Whenever a user creates an Article i want to genrate a permalink for each article so that navigation is simple instead of using query strings and exposing article id to common …

0
92
Member Avatar for lewashby

The program below is just a simple test to see if I can get it to fetch the correct data from MariaDB and then display it on the screen but so far I'm not having any luck. I left the action attribute's value blank because I want the PHP form …

Member Avatar for cereal
0
591
Member Avatar for Saboor880

Hello to all! I am facing problems in feartures of sql sever 2008. I installed it but i could not find management studio in it. then i installed managemenet studio2008 separately. but when i opened management studio then there was no interface for making database but only interface was for …

Member Avatar for cgeier
0
320
Member Avatar for hollinar

Hi.. I have a big problem, hope that you can help... I have windows 2003 server with CA brightstor 11.0 (Build 2670) and is making backup to all my SQL Servers. so I need to restore a database where the MDF file is 4 GB and the LDF file 111 …

Member Avatar for marimeli
0
1K
Member Avatar for azapovjednik

Hello all, I have an MS SQL table. There are two columns I need to work on: HOURS_DURATION and MINUTES_DURATION. They are of INT type. As you may see in the photo I am attaching: [TABLE SAMPLE IMAGE](http://prntscr.com/8gzg7c) Now, I am making a fast report. And for now I have …

Member Avatar for Taywin
0
149
Member Avatar for emilianjobs

Hello, I have a table with a filed Customers defined as int(10) I have the following query: SELECT * FROM 'table' where `Customers` = 'a' This query returns all entries which have 0 in this field, BUT a is not equal to 0 as we know? Also I can use …

Member Avatar for diafol
0
204
Member Avatar for sing1006

cmd.CommandText = "UPDATE tbl_System SET S_Name='" & TextBox2.Text & "', S_Function='" & RichTextBox1.Text & "', S_Failure='" & RichTextBox2.Text & "' WHERE EquipTag='" & Tbl_SystemDataGridView.CurrentRow.Cells(0).Value & "' i think this is correct format for update query but i still get error for this

Member Avatar for sing1006
0
261
Member Avatar for boomtifier

i need samples on calculating average the average of "C Program=50" "Html5=70" "DreamWaver=70" "SQL Server=80"

Member Avatar for ddanbe
0
205
Member Avatar for ManikandanM

Please guide me. Im begginer in Sql. Im working through task tracking system in php. I need know how to display particular username details using query? Since Im getting all userdetails by single username and password..

Member Avatar for rotten7
0
86
Member Avatar for mbowenitj

Hi everyone, I need help in selecting between date ranges. I have two dateTimepicker and want to retrieve only records selected between selected dateTimepicker.I tried but im getting all records. I'm using SQL server database. Here is my code: selectQuery = "SELECT * FROM EmployeeRegistration WHERE EmpJoinDate BETWEEN '" & …

Member Avatar for Reverend Jim
0
176
Member Avatar for shashigowda

how to export asp.net(using sql server as database) project from localhost to godaddy server??please help me

Member Avatar for tarunap
0
112
Member Avatar for Tinnin

Hi everyone, I have about 20 simple queries running seperately on loading a php page with mysql querying. On my localhost the page takes about 3 seconds to load but on the live server this is over 30 seconds. I'm trying to shave some time off but I'm having trouble …

Member Avatar for Taywin
0
305
Member Avatar for gbhs

Greeting to daniweb I must partition by Type and rank the following datable ( called dt) by LoanAmt column with ties Type LoanAmt Rnk ==================== A 14 A 15 A 13 A 11 A 11 B 17 B 18 B 17 B 16 As a new learner, I have read …

Member Avatar for gbhs
0
128
Member Avatar for Chris920

Not sure if that is the correct title, but I created an additional field in the users profile. I want to add that field with the option to change that field (its a drop down) on the main homepage as well as profile page. It would be the exact same …

0
113
Member Avatar for Christopher_12

i would like to know if it is possible to translate my code according to a database(currently using microsoft sql server) the code i have it is encrypting and decryption on a file inside the microsoft visual studio project i want to connect it to the database this code is …

Member Avatar for Reverend Jim
0
491
Member Avatar for mdavis28

Hi, I have recently started working with SQL databases of which I have 0 previous experience. I have added the datasource to my project using the Visual Studio wizard and the DataSet appears in my solution explorer. Everything that I have read thus far has shown connecting to the SQL …

Member Avatar for JOSheaIV
0
159
Member Avatar for Christopher_12

i am new in this encryption and decryption i would like to have my encryption appear on my database (currently using microsoft sql server) i create 3 forms : one for the registration which means when u will register, u will be able to access the 3 forms by entering …

Member Avatar for Reverend Jim
0
315
Member Avatar for Saboor880

Hi! I am facing problems with sql server 2008. I installed sql server 2008 and it was installed successfully. But when i went to start menu then only following features were displaying 1- sql server configuration manager 2- send errors and reports 3- sql server installation center. But other features …

Member Avatar for Saboor880
0
295
Member Avatar for Q2X5

Hi Every one >>> I'm doing visual basic program with sql server database I need to Export database to but it in my own server and connect to my prgram but i can't do it could you help me ...

Member Avatar for pritaeas
0
66
Member Avatar for md.Rayad

I have a oracle query and i would like to run it by powershell using ODP.Net. Below is the query. set pagesize 100 set linesize 200 break on report compute sum of free_mb on report compute sum of act_size on report compute sum of used_mb on report col %used format …

0
252

The End.