[database-sql] Forum Topics

Hi everyone! i have a question that, if there are two radio buttons Male and Female, if some select male,this value will be store into database, but if he select again another value which is female,then how the first value(Male) will be replace by second value (Female) in the database …

Hi all, i have userid ,username,password now i want login using this query how; select username,password from tablename where userid=userid;

How can you get the alternate records from the table in the SQL?

hi, i have installed XAMPP, but i would like to run my localhost from another computer..

I am facing issues using logical operators to perform operations in SAP HANA. Can anyone help me?

Hi, I need help to create a relational database for shop.The database should contain a column for barcode in order to register items and also to read details of items using barcode scanner.Besides this database will contain tables for performing all operations for shopping store items what are those operations …

Which SQL data types can be used in SAP HANA?

Hi group, I've just installed Visual Studio 2019 and have started my first app using this. Within the program I created a database using the tools provided in Visual Studio. I now want to begin writing to the tables I've created. But I'm stumped on how to do this. Hopefully …

How can I create different types of joins in SAP HANA?

Guys, do you know if I can use SQL in Mobirise? As it's a pain to set all coming mail to separate file manually out of Mobirise's forms. I'm not sure that it's possible to bring any changes to the code of the forms at all. Thanks

In Access I want to group and assign data according to conditions with 2 values 0 and 1 (true or false) and with the condition NGAYGIAO>= #01/01/2019# and NGAYGIAO <=# 31/01/2019# me How to write commands ? The data I put in the excel file consists of two sheets: Original …

So I am attempting to do an ER diagram over a login, with just login data, and the base data of the person loggin in, and the connection between login_ID and Basedata/Stamdata_ID. Is this correct, or how would you guys do it?  http://prntscr.com/mskpli

hello everyone im taking database course this year and it's my first time to take it so i need help how to draw a ERD for following busniess case AND IF there many to many relation how i can establish a new relation ! Entity (Artist ) Attribute : death …

Hi Guys! I have a website but we don't host in GoDaddy or any hosting website, because we use SQL database. And we have a large database that we are using , the website is for productions. We store a lot of data. We use the IP address because we …

When i run the statement below i am getting a number of xxx.xxxx can anyone help me change this to two DP? (SELECT sum(oht_net) FROM order_header_total JOIN order_header ON oh_id = oht_oh_id WHERE oh_cd_id = cd_id AND oh_sot_id = 1 AND DATEPART(yyyy, oh_datetime) = (SELECT DATEPART(yyyy, GETDATE()) -1))

I have a function that I need help with. The purpose of the function is to sort an array of objects by field. This function was using the PHP function create_function which is now deprecated in PHP 7.2. I've been trying to rewrite the function, but the results return null. …

How to prevent Illegel/ Logically Incorrect Queries? Illegal/Logically Incorrect Queries 1)Original URL:http://www.arch.polimi.it/eventi/?id_nav=886 2)SQLInjection: http:/`/www.arch.polimi.it/eventi/?id_nav=8864' 3) Error message showed: SELECT name FROM Employee WHERE id =8864' from the message error we can find out name of table and fields: name; Employee; id. By the gained information attacker can arrange more strict …

Hello, I am trying to prevent SQL Injection on Codeigniter. I am reading this link: https://www.roytuts.com/prevent-sql-injection-in-codeigniter/ I do not understand what is the purpose of Escaping Queries, Query Binding and Active Record. Thanks in advance.

Hello, I am in the middle of learning about IT Security. I wonder why sometimes people uses ASCII value for SQL injection attack? Do you know the reason why? Why not using normal ' mark.

I have this use case where in I would need to dynamically create java objects out of json input and insert the data into sql tables. I tried using gson APIs but unfortunately we need to specify strucuture of that class (Car.class). Is it possible to dynamically achieve the above …

2018-03-01 19:50:40.224088 [ERR] switch_core_sqldb.c:1197 SQL ERR: [select call_id,sip_user,sip_host,contact,status,rpid,expires,user_agent,server_user,server_host,profile_name,network_ip, network_port,0,sip_realm from sip_registrations where expires > 0 and expires <= 1519905040] database disk image is malformed

I need a list of all 5160 name Indian cities by district name in xls/csv or sql format. Where can I find them?

how to link data base delete button to the website delete button

SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy"); Date date = sdf.parse(d); Calendar cal = GregorianCalendar.getInstance(); cal.setTime(date); for (i=0;x>i;i++){ cal.add(GregorianCalendar.DATE, 7); String t = sdf.format(cal.getTime()); DefaultTableModel model = (DefaultTableModel) jTable1.getModel(); model.addRow(new Object[]{t,c}); }

I am creating a reporting engine, it is kind of novel. **The only question I have is what are some of the wierder scheduling related things you guys have seen for you cyclical computer programs to date**. I am trying to cover as many fringe cases as I can, and …

i need to update when user i come on left or right side if colums in table when user come with register then count leftcount 1 , if user come right side then count , in colum rightcount . plz any person can help me?

Hi, guys I am working on vb project, which will save client database. I've done the coding of ADD, NEW, SAVE, EDIT button. Now, I am stuck at DELETE button. When I delete any particular client then I want my client_id (it's a column in my access database) should get …

I have a table with nutrient data(in Dutch) it looks like this  My DB design skills are very low, I only know Mr. Codd is lurking 'round the corner somwhere. Could anyone give me some hints on how to set up my tables or should I just usr …

i have db table as product_master,in that product master have many products and each product have minimum cost and maximun cost,my doubt is,in ui,i select product in one dropdown text box,dynamically another dropdown text box select that selected product's minimum and maximum cost,how can i do using select query???

I haver an IIS server with an mvc 5 app im developing and i have had no luck so far getting the windows authentication working with my app, i have it set to windows authenication but the app will only auto login users when accessed from the server. Then once …

If a table contains field's like name,age tuition fee,bus fee,year, 1,2 When I tried to update 1 year details it is updating but when I try to update the entire fields it's not updating in form of jsp page

I'm having the following difficultly: I have a table `rates` which contains the follow: -> id -> rate_from -> rate_to -> price A `user` can have many rates, and for an example: between 0 - 10 hours the `user` charges `10.00` an hour between 10 - 100 hours the `user` …

i want to combine multiple rows into a single row using **DB2**. I have found this code, but I do not know how can i edit it>? CREATE FUNCTION MySchema/MyUDF ( PARCol2 CHAR(5) ) RETURNS VARCHAR(1024) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA CALLED ON NULL INPUT DISALLOW PARALLEL BEGIN …

Hello, I have make a ERD. And there is a case. Can someone look to this both? Did I forget something? Would anything else have to be done? my case is: A hotel guest can be a main guest or a travel companion. Only a major guest can book and …

Exception in thread "AWT-EventQueue-0" java.lang.Error: Unresolved compilation problems ???? how to fix anyone help me ??

Hi, i would like to know if it is ok to use SQLCE for a big software like SCHOOL MANAGEMENT SYSTEM or LIbrary Management System. If NO. Why? Thank You for your help..

please I'm a student of standard institute of tech.. studying comp. sci., we've been asked by our lecturer that all of us should look for all way to view answer on an online CBT(Computer based testing) test which is powered with asp.net, js, HTML, css. plz I'll really appreciate your …

I have a datagridview that contains a linklabel I want when I select each line and I click on the link the program shows me the relevant data line And thanks in advance

Hi, For my school assignment I am making a to-do list program in visual studio 2015, hence I will need a database to store all the data. I was wondering, for such a program which database will suit best. I was thinking excel, but I am not sure. Thanks, Anshul

How to display picture stored in MS access to PictureBox in vb.net I make a login form that require your username and password and picture to login successfuly

when i upload image in form using cakephp at that time the image is insert but other data will not inserted...??

Dear Friends, I made login form in php ... when i login .... URL shows form Name in URL Bar.... that means i can open the from without username and password. for example. http://www.nig-bh.com/registration1/login.php this is login form when i enter username and password it opens http://www.nig-bh.com/registration1/enqrep.php ...after correct username …

Ok, so this site sell me on developing a website saying "Death to the DIY" MoPro is another cookie cutter platform that says they will build it but..... well you tell me. eeshop.us I need help to understand how to put content, products and vblogs on the site. And if …

Hi can any one please help me with some sample for multiple textbox value in php search. all the fields in the search are in one table. I have attached screen for the reference. 

Hi everyone, I have a submit form on my website that display's to the user once is has been submitted, The problem I have is the text is being displayed as Chris &amp; Amy\&amp;#39;s 30th It should be displayed as Chris & Amy's 30th What is the best way to …

HI all, I'm stuck in a code where i cannot read the database value in jsp textarea. Value stored in database like "address 1 address 2" and cannot be loaded on jsp page. Plz help.

I'm sure I've mentioned this type of wrapper class for accessing databases in a provider-agnostic manner before, but never posted a functional implementation. So here it is. Questions, comments, and suggestions are welcome as always. :)

hello i started visual basic in access and wnted to use INSERT INTO , thats the code: Dim arr As String arr = "INSERT INTO customer product(user) VALUES('" & user.Text & "')" thanks for help

I want to make countdown timer in multiple choice. I want to display question one by one. But when I click next for the next question, the time is start from 10 minutes again, not continue. How to make an alert if the time was over, it would be directly …

If user issues a query, I would like AJAX to download the result of query into browser so that JavaScript can do the parsing. The results could be around 1MB-5MB (at most, doubt it would get anywhere near 0.1MB), and I would send it from PHP to front-end using JSON, …