[sql] Forum Topics

I have a table of names that have done something on a certain date, now this could be over and over again yet of course on different dates but never the same. I need to update a field called last_time that corresponds to the previous date that they occur and …

Hi, I'm running a C++ program (HPCG benchmark) on an ARM processor based board (Juno) with 64-bit Fedora 21 OS. When I run perf top in another terminal to find which functions are taking more CPU time, I get an output like below. 75.84 xhpcg [.] ComputeSYMGS_ref 22.27% xhpcg [.] …

I have SSRS column chart in which data of percentage complete for half day and full day is shown . The 4 legend series are half day complete,half day incomplete,full day complete and full day incomplete.Months are shown in x axis and percentage in interval of 10 on y axis …

Hello, I have created many section like update delete etc on the webpage i stored a message in the session variable so when users updates deletes etc on the page a message comes up logo updated sucessfully message posted successfully etc etc so that message is stored in session variaable …

PHP is an object-oriented language, based (loosly) upon C++. It has classes, methods, member variables, and all that other good stuff. It runs on your web server, not in the client, but the HTML, JavaScript, and other stuff such as CSS blocks that it emits with its output commands are …

My SQL2000 server crashed, and I was able to recover the data and log files. I had to reinstall from scratch after that. I found that I can use the sp_attach_db procedure to create databases on the new server from the data and log files. That recovery procedure worked, at …

hi i used multer to create an upload script now i would like to display the photos uploaded by eacch user on diff pages with diff adrees i.e exprome.come/photos/234 and also every photo would have its comment. any ideas? i think every comment should be saved with the photo id …

Hello Is it possible to use SQL queries in a JS file? Example I have the following code, and would like for each input[type='text'] encountered, to save its value to a sql table in a column: jQuery("input[type='text']").blur(function(){ var id = jQuery(this).attr('id'); var inputVal = jQuery(this).val(); });

My problem Im almost certian is a permissions issue but im still very new to this so bare with me. I have a server running the latest mysql with mysql workbench installed and im tryign to modify the users and privilieges for either my one table or all my tables, …

Hi im attempting to copy a php code and get it to work with a script im trying to create and i have come across the error below can anyone tell me whats going off any help would be much appreicated x You have an error in your SQL syntax; …

-1 down vote favorite Here I'm facing problem with course registration. I have 3 tables named as dept(dept_id,dept_name) where dept_id is a primary key 2nd table is semester (semester_id, semester_name,dept_id) semester_id is a primary key and dept_id is a foreign key .3rd table is courses(c_id,dept_id,sem_id,c_name) where c_id is primary key …

Hello Everyone, it seems that I cannot see the wood for the trees.... :-) I am having problems with this line of code... StateSQL = "select * from petrol_table where fueldate >= " & "'" & M12S & "'" & " and fueldate < " & "'" & M12F & …

Hello All, I have a table with column_name as USERNAME where USERNAME is VARCHAR2(20) and I want to display it as **"USERNAME@email.com"**. How to write the select query for this. **QUERY**: SELECT USERNAME AS EMAIL FROM STUDENT Thank you.

How to fix the following SQL error? 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`Sent`, `handler` varchar(20) NOT NULL, PRIMARY KEY (`id`) )' at line 5 Code: $create_q = 'CREATE TABLE IF …

Hi group, I'm getting an "single-row subquery returns more than one row" error when running my routine. Looking through the table I'm querying, it is listing a date twice for some reason. Since I'm not able to remove this one row, is there a way to return the first instance …

dear members, i need help, i have one datagrid and two dataset with two diff. tables, what i want is to insert data into datagrid and save grid data to other tabel in sql server.

Hi all, I am not able to get correct count, if col1 (percentage with respect to product) and col2 have uniq value. Below I post my sample table data and expect output and which i query I tried. Please help me to get in to right direction. CREATE TABLE mysample …

hi i picked this script up from a site and im trying to install it in my system and i came across the error below 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 …

Hi, I'm using PHP, I am trying to develop: 1. a login page in HTML, once user enter the correct username and password, this will be directed to the User page. 2. In User page, there will be some text fields of the user (eg. name and address), all these …

hello: i was given a corrupted mdf file, the server the database (sql 2000) crashed and the only file recovered was this .mdf file. I have tried as many of the options that i can find, and still cannot get this database recovered. downloaded several of the programs that claim …

The Database ID 5, Page (1:9248), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE I am having above error on sql 2008 R2 , i have identified the table which …

I wasn’t sure which forum to put this under so I just selected web development. I have run into an issue that ironically I have solved before but thanks to my wonderful drop-box the changes I made were not saved and when I changed them again on another computer, the …

Hi . I am writing sp that i will use for generating SSRS reports . In the sp , i hv passed month name as input parameter. I am able to get the required output but need to filter it based on months .i.e entries present for current month upto …

I’ve been looking and researching ASP.NET hosting provider for the past few weeks. Please kindly help me to choose the best hosting provider for me. I will be more details about my requirement below. I’m leaning towards Microsoft Azure Web but a bit concerned about the price. I will talk …

I want to add data to sql databse using vb.net form And I am new to programming :( I get an error message saying "Incorrect syntax near "deatails") Can somebody tell me the reason the following is the code I'm using Imports System.Data Imports System.Data.SqlClient Public Class Customer_Profile Dim con …

I want to ask how to pass the '30','31','32' to SQL WHERE IN clause For example EXEC SQL DECLARE abcd CURSOR FOR SELECT Consignment FROM Transaction WHERE order_type IN (:dest) where dest will hold the value '30','31','32'. I have tried as above example but it is not working SQL did …

I am a 19 year old guy who is yet to get a CS degree from the university. I learned web development on my own from resources online. Mostly from youtube videos precisely from thenewboston and phpacademy and a few text-based tutorials from w3schools.com. I am good with HTML, HTML5, …

[Click Here](http://dev.appcotech.com/pwrdup/static/become-postie.php)[1] UnderConstruction please go to upper link and click on SIGNUP TO DRIVE (Blue cruve Button) there will be a tab open type `london` (Not From Drop Down) only just type `london` and hit enter page will redirect to dev.appcotech.com/pwrdup/static/become-postie-vehicle.php page (This mean post keyword matched 100% with database) …

Hi there , How to write multiple update_batch query in codeigniter? My script is not working ... Please give some solutions for multiple update row using update_batch... getting below Error: A Database Error Occurred You must use the "set" method to update an entry. Filename: D:\xampp\htdocs\DEAL\system\database\DB_active_rec.php Line Number: 1273 mycontroller …