Member Avatar
How do I write a SQL query involving a time stamp? QUOTE_ID is a character string CREATE_DTG is a date time type RETENTION_LEAD_TRACK is a table This sql statement ... throws this error ...
by complete -2 in Databases ()
Member Avatar
I want to insert a table cell into a table from another table by select method and after, to display an error in text prompted from the user was not found. Can someone tell what's the problem with my codes? My codes are as follows: ...
by tshukela.george in Software Development ()
Member Avatar
Let's say I have such table: ... I'd like to select every single result in this table, where user with ID ... has partcipated. How can I do that? Ye old ... . Couple things worth noting, that in this particular field, there may be just alone ... , or …
by RikTelner 20 in Web Development ()
Member Avatar
Hey fellas, some time ago I started trying out Brackets, and guess what? Loved it! If you don't know, it's an open soude editor made out of html, css and javascript, powered by node JS and chromium and sponsored by Adobe. A lot of open sources projects coming together to …
by AleMonteiro 238 in Community Center ()
Member Avatar
Fell virtual server, yesterday raised and moved onto a new backup of 02.12.15 number of backup, whether it is possible to restore the database with a log of the ldf 12.24.15 number
by judgerm in Databases ()
sql
Member Avatar
Please explain to me what execution plans and index creation is in Oracle SQL. An example would be great also. Thank you!!
by Emily_3 in Databases ()
Member Avatar
Hi Friend, ... Error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. please solve my problem. Thanks & Regards
by Parth_3 in Programming ()
Member Avatar
Hey ! I'm looking for sql 'like' command help.... I had mysql database and it had settlement table. On that table there is column named 'settlement'. In the settlement column there are so many amounts..... Now I want to find recors '0 values' Can anybody help me ?
by sashiksu in Databases ()
Member Avatar
Hello, I was looking for some help with the below query. I need to only return the first 'Carton.CartonNumber'. I tried adding something like ( Select Min(Carton.CartonNumber) as FirstCarton from Cartons group by Carton.ID) dispite much Googling but cant get it right because of all the other joins confusing me. …
by tig2810 in Databases ()
sql
Member Avatar
Hi all, I currently have two tables that look like this: ... I use two queries to get the number of likes and comments in relation to any profile post: ... ID ... and ... ID ... I have been trying to combine these into one query. However, I get …
by James_43 15 in Databases ()
sql
Member Avatar
I need to transform between two different database schema the same data. For example i have one table in old schema looking like this: OLD EMPLOYEE TABLE USER_ID - NUMBER (PRIMARY KEY) FIRST_NAME - VARCHAR(50), (NOT NULL) LAST_NAME - VARCHAR(50), (NOT NULL) CITY - VARCHAR(50), (NOT NULL) and i need …
by Peter_26 in Databases ()
Member Avatar
Hi, ... strProfile can be blank, so if it is blank then this AND PD.Profile = strProfile should not be included in the where clause, How do I bypass this? Cheers Darren
by DGULLIVER 10 in Databases ()
Member Avatar
hello guys i want to disconnect a mssql connection automaticaly whit a command
by mehran199107 in Databases ()
Member Avatar
My project uses local sql database. I tried the app on a non development machine for first time. Got a message saying it was downloading required files, sql 2008 express, at a whopping 600MB+ file. Please tell me I've done something wrong, and any user of my app will not …
by Suzie999 229 in Software Development ()
Member Avatar
Hello to all! I am using Sql server express 2008. Now I want to use Integtation services such as creating and executing packages. But I could not find any interface to create and execute packages in version of server which i am using. When I go to start menu > …
by Saboor Siddique -3 in Databases ()
sql
Member Avatar
I m in the process of creating a sql table which acts as a stafflist that has several columns like name , number , email and delete. One webpage on the website gives out the rows of this table and i would like to have a clickable link in the …
by latrellvie in Web Development ()
sql
Member Avatar
Hello, currently on one of my development servers I have SQL Server 2014 installed, the problem I HAD was that when I executed any of my PHP sites connected to various databases I was getting ... I fixed that error by forwarding the port through the firewall, however I get …
by toxicandy 2 in Databases ()
Member Avatar
My php file connnects to my sql database , following code works ... after that a staff listing which is written in html shows BUT if i use following code to get data out of my sql to display I only get a blank screen ... I wonder where is …
by latrellvie in Web Development ()
Member Avatar
Hi, I hope I've posted this in the right place, please just tell me if not. I've been having an issue with connecting to a database from a website and have recieved this as an error message: I then followed what it said and tried to download the Native Client …
by az_ez in Microsoft Windows ()
Member Avatar
hi i have followed a online tutorial to replace photo system on my site and all went well till i attempt to upload photo i get no file selected even if i have just gone on the page but after pressing submit i get a success message and the photo …
by janicemurby in Web Development ()
Member Avatar
hi i got another syntax error in a script that i am fixing to add onto my main site can someone take a look to see whats going off this error is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version …
by janicemurby in Web Development ()
Member Avatar
hi i managed to change my site from mysql to mysqli with all your help although i have one line thats causing me problems in inbox.php can someone check this out and see whats wrong the error im getting is Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given …
by janicemurby in Web Development ()
Member Avatar
Greetings, I have a database creation script. I've run the script after changed the path within the 'FILENAME' option to create the database on an external hard disk and I was able to see and select data from tables as the script run with no errors. However, when I tried …
by Amr.Mohammad87 6 in Databases ()
Member Avatar
I'm trying to load dxf files CAD into a database for searching. Some of these files are huge with hundreds of thousand of separate entites. I've separated the file into the following tables: drawings layers style entities points flags floats text The drawing table contains a path to the drawing …
by davecoventry 8 in Databases ()
Member Avatar
Hy there! I have prestashop 1.4.4.1 and i want to export database clients in CSV through Mysql. I want all the fields possible. Is possible to export their passwords also?I mean MD5. Can you please help me? Best regards, Florea Uwe
by Florea in Databases ()
Member Avatar
Hi, Can you guys reccomend me some good oracle sql journals? Thanks
by Mohamed_26 in Databases ()
Member Avatar
Hello, What are the different areas of databases I can focus on for my project? Thanks,
by Mohamed_26 in Databases ()
Member Avatar
Hi all, If I have two table of cod-desc, T1 and T2, and I need to create all possible combination, other than using cartesian product, is there another way more optimal to do that? Suppose every table has 1M rows. RDBMS= Oracle 11G. Thanks sandro
by sangi1981 in Databases ()
Member Avatar
I have a quick question, I am hoping it is an easy answer but if I wanted a query like the following: ... Is there anyway to replace the order by information with prepared statement attributes? would either of the following work? ... OR ... and then use bindParam or …
by toxicandy 2 in Databases ()
Member Avatar
I need some help writing a sql query. I have below 2 queries and I want to combine them together. Now I already tried union but it doesn't work. I first want to print all result of query1 than I want to print all results for query2. Ex: --Query#1 results: …
by hwoarang69 11 in Databases ()
sql