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, 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 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 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
Member Avatar
I am writing a custom MembershipProvider for ASP.NET and would like to record certain events in a table when they happen. I have the methods to do it, but I would like to get the value of the "ID" column of the row I insert into the table. I have …
by zachattack05 56 in Software Development ()
Member Avatar
Hi. im developing a loan processing system using mvc c# asp.net. One of the requirements of the system is to perform a credit history check on the customer applying for a loan. so this is how it works: -the customer applies for a loan. the customers id number gets stored …
by 21303359 in Software Development ()
Member Avatar
Bold Text HereHowdy All, I'm creating a database for UFO sightings and would appreciate some feedback or suggestions. Yes I know, strange topic. Some background info so that the problem is understood: I'm extracting data from several large UFO database catalogs, news articles, and other miscellaneous sources, so that the …
by gil857 in Databases ()
Member Avatar
I'm working on a personal movie database project to help keep track of my movie collection, but I'm having issues and I was wondering if it was even possible and if so how to go about doing this in the first place. I want a way to get an overall …
by jdm in Databases ()
Member Avatar
Hiiii,Good Evening I have a code that search for data in the database but I can search for only 1 keyword in a time,which is working fine for single keyword. if I type 2 keywords separated by a space or comma's which return blank page. I would like to modify …
by shashigowda in Databases ()
Member Avatar
Hello All, I need a bit of advice regarding my final year project. I dont want any help with code but just on what path I should take. My project based on using triggers to solve business problems. I am not sure, on how I should approach this really. if …
by Mohamed_26 in Databases ()
Member Avatar
Bold Text HereHi there I'm just wondering what the best or a good table layout would be for a little project I'm trying to do at work. I work at a temp to perm agency where companies use us for the probationary peroid of employement and then hire the workers …
by ScottieF 18 in Databases ()
Member Avatar
hello A newbie in database constuction, need help in adding automated sms functionality in mysql database. A user needs to sent a certain sms with certain keywords like 'location' to the system. the system refines a search according to the location content then sents back the data back to the …
by andrian.mutua.7 in Databases ()
Member Avatar
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. ... Now in search bar, …
by hwoarang69 11 in Databases ()
Member Avatar
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 …
by nosfa in Web Development ()
Member Avatar
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) ... When a user attempts to …
by zachattack05 56 in Software Development ()
Member Avatar
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: ... Now, I am making a fast report. And for now I have a simple …
by azapovjednik 14 in Databases ()
Member Avatar
Hi guys, i am creating a search function on my web. This is the result "SELECT [ROUTE], [INST_KEY], [INST_TYPE], [ACCT_KEY], [STATUS], [DMZ], [CUST_NAME], [ADDRESS_LINE1], [ADDRESS_LINE3], [ADDRESS_LINE4], [ADDRESS_LINE5], [METER_KEY], [SIZE], [INSTALL_DATE], [X], [Y], [Z], [ADDRESS_LINE2], [MI_PRINX] FROM [DBCUSTOMER] WHERE ([CUST_NAME] LIKE '%' + @CUST_NAME + '%')" This function just looking one …
by kikiwisaka in Web Development ()
Member Avatar
Hi. Below is the code which parse data from mysql into json, but for the name column i want to have <a href=" ... ">column name</a> instead of jst the column 'name'. is it possible in any ways. ... Thanks
by Mushfik in Web Development ()
Member Avatar
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 …
by mpc123 15 in Databases ()