For this particular sub I type the customer id in a text box and then click the button, then I'm trying to get the relative information pertaining to that id. Not sure what I am doing wrong. Comes back with an error message of system.data.sqlclient.sqlexception Recursive common table expression '[customers]' does not contain a top-level UNION ALL operator. Private Sub FillByCustomerIDToolStripButton_Click(ByVal sender As Object, ByVal e As EventArgs) Handles FillByCustomerIDToolStripButton.Click Try Dim customerID As Integer = CInt(CustomerIDToolStripTxtBox.Text) ' LOAD THE CUSTOMERS TABLE WITH THE SELECTED CUSTOMER. Dim id = Me.CustomersTableAdapter.FillByCustomerID(Me.DatabaseDataSet.customers, customerID) If Me.DatabaseDataSet.customers.Count > 0 Then For Each row As …

Member Avatar
Member Avatar
+0 forum 2

I want to see your suggestions on comparing CPanel and FASTPANEL. I used CPanel for some time but later I changed to FASTPANEL which is absolutely free but provides you with the same opportunities. Also FASTPANEL's design looks much better than CPANEL's one. So now I can't understand why people pay for CPanel. What panel do you guys use and why?

Member Avatar
Member Avatar
+0 forum 5

Team, Hope you all are doing fine I have one admin server which is being used dedicately to run cron jobs on hourly basis, fetching the details from Database which is in a different server.These cronjob are run on every hourly/5 minutes basis depending as per end user requirement. The cron jobs are basically reports which end users need for their records OS version is Red Hat Enterprise Linux Server release 6.6 where the cronjob is set Now the tricky point: 1)Since last week, everything was getting run once, but when we query the database we are seeing duplicate entries …

Member Avatar
Member Avatar
+0 forum 2

I'm a novice in PHP and I would like to know on how exactly could I define said row. Any helps/tips are appreciated. Thank you in advanced! function add_review() { if(isset($_POST['add_review'])){ (THE UNDEFINED ROW) **$product_id = $row['product_id'];** $review_name = escape_string($_POST['review_name']); $review_email = escape_string($_POST['review_email']); $review_content = escape_string($_POST['review_content']); $review_created = date("Y-m-d H:i:s"); $rating = escape_string($_POST['rating']); $review_query = query("INSERT INTO reviews(review_id, product_id, review_name, review_email, review_content, review_created, rating) VALUES('NULL', '$product_id', '$review_name', '$review_email' , '$review_content' , '$review_created' , '$rating')"); confirm_query($review_query); set_message("Thank you for the feedback!"); }}

Member Avatar
Member Avatar
+0 forum 1

Hi all, I am very new to PHP and MYSQL and have a class assignment I need help with. I am trying to make a page with an HTML form that will update my MYSQL database. You can view my pages online here: [URL="http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php"]http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php[/URL] I need help with the "Edit" section, if you look online. Here is the code for my Edit page: [CODE=PHP] <?php $hostname = "localhost";//host name $dbname = "baileyjumper_imd203";//database name $username = "baileyjumper_imd";//username you use to login to php my admin $password = "chris4ever";//password you use to login //CONNECTION OBJECT //This Keeps the Connection to the Databade …

Member Avatar
Member Avatar
+0 forum 21

Got Client with need of **"online print shop"** Client is providing paper printing (like business cards, flyers), printing on cloths, office stationary, logo embroidery on any type of clothing. Client provided some examples. **Links** * [rockdesign](https://www.rockdesign.com/) * [moo](https://www.moo.com/ca/) * [readyprint](https://www.readyprint.ca/) * [vistaprint](https://www.vistaprint.ca/) * [printshop](https://printshop.ca/) * [printvenue](https://www.printvenue.com/) **Where do I start?** Which platform should I choose? 1. CorePHP 2. Wordpress 3. WooCommerce 4. Magento 5. Prestashop 6. WordPress Is there any plugin or script that should I go for???

Member Avatar
Member Avatar
+1 forum 14

dear all i have a invoice table now in that datagrid table i have 4 columns itemcode itemdescription qty price now what i need is user come to itemcode and whenever he type itemcode, he should get a list of initial alphabetic itemnames like if i type A so itemcode must show all items codes related to A and when i get my required itemcode, after pressing enter it should fill the related field (item description,qty,price) please guide with codes thanks

Member Avatar
Member Avatar
+0 forum 7

I'm somewhat new to coding websites. I'm trying to have a code where it pulls multiple images from a single database and displays it in a grid, not a table. At the top of my page I have a normal connection to the database. (very sorry about not having a code snippet, I'm new to daniweb and keep having errors when trying to use code snippets.) <div id="grid" class="grid-container"> <?php while ($row = mysqli_fetch_array($query)) echo '<div class="grid-item"> <p>'.$row['images'].'</p> <p>'.$row['project'].'</p> <p>'.$row['summary'].'</p> </div>'; ?> </div>

Member Avatar
Member Avatar
+0 forum 1

Hi, In my application two fields are the user id and user name,i want to show the user name and user id along with other details in a html table. user id is a numeric dropdown menu and user name is text only.How can i show the specfic record in that table for that user which i have selected in both of the fields ,how i can fetch data from backend User table?am using html,css and javascript, Any suggestion would be grateful!Thanks..

Member Avatar
Member Avatar
+0 forum 1

Hello i have a project that uses firebase but i want to make connect to my MySql database on xampp. Any idea what to do?

Member Avatar
Member Avatar
+0 forum 1

Below is my code for adding parameters in my vb .net code for prepared statements of npgsql. Dim xConn As NpgsqlConnection = ConnectDB() Dim xCmd As NpgsqlCommand = xConn.CreateCommand() xCmd.CommandText = "UPDATE " & xTable & " SET previous_tot_adj = @prev_adj ,tot_adj = @tot_adj WHERE version = " & _version & " AND monthly_mq_id = @Index" For Each Index In _Results.Keys If Not IsNothing(_Results.Item(Index)) Then xCmd.Parameters.AddWithValue("prev_adj", NpgsqlTypes.NpgsqlDbType.Double, _Results.Item(Index)) xCmd.Parameters.AddWithValue("tot_adj", NpgsqlTypes.NpgsqlDbType.Double, _Results.Item(Index)) xCmd.Parameters.AddWithValue("Index", NpgsqlTypes.NpgsqlDbType.Bigint, Index) End If Next xCmd.Prepare() xCmd.ExecuteNonQuery() After executing this code i get this kind of error . > A first chance exception of type 'Npgsql.NpgsqlException' occurred in …

Member Avatar
Member Avatar
+0 forum 2

Hi, I am a legacay (cobol) developer and wants to learn how to build websites. For this I decided to do a little project for myself. The site would be a places/travel tracker kind. It would show a certain map (ex, London, Taiwan, Greenland). Then you can click on a city on the map which will show pictures/videos/comments of you in that city. Map changes color for the city you have visited or maybe a pin. I have search the web and mostly there are world tracker. I would want a country based one. So my questions are: 1.) What …

Member Avatar
Member Avatar
+1 forum 4

How can I show the database in a single mode (windows or SQL authentications mode) please help me..... How can I Show the database in a single mode (windows or SQL authentications mode) please help me. I create a project VB.NET 2010 and SQL server 2008r2 , When I login sa account show the database it is all right. But problem is when I connect windows authentication mode same database show on there, and it is fully accessible. I want to when I login sa account show the database, not show when login in windows authentication mode.

Member Avatar
Member Avatar
+0 forum 1

How to the excel data please help me In the original excel sheet data show column wise. But now I want to same change to data showing structure and re arrange the data structure. I can't upload the excel sheet that for i attached the IMG please help me https://ibb.co/jdzC4m I mean my original data is column "A" to "K" and row 1 is heading row 2 to 5 is data I want set data as per column "B" to "F" and row 7 is heading and row 8 to 22 is data I want do it using formula I …

Member Avatar
Member Avatar
+0 forum 3

I have a list.php which displays all the records that is in the database with 2 options Edit or Delete. When clicked its suppose to delete by id but instead it deleted everything. I'm not sure where i went wrong, please help. list.php <?php include "db.php"; try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $conn->prepare("SELECT * FROM myguestbook"); $stmt->execute(); $result = $stmt->fetchAll(); //fetchAll() function will grab the query result and store it in an associative array $result. grab more than one record. } catch(PDOException $e) { echo "Error: " . $e->getMessage(); } $conn = null; ?> …

Member Avatar
Member Avatar
+0 forum 5

Dear all, I have a scenario, where I have a single table with all my users listed in them. Each user also has a field indicating the user they report to. UserID UserDisplayName UserReportsTo ----------- ------------------------------------------------------------ ------------- 8 Anthony Karimi 3 9 naheed kassam 8 1 Administrator 1 3 Ramakrishna 2 2 SB 2 (5 row(s) affected) In my scenario, i need when the user selected is say userid = 3, then the table displays userid = 3; userid = 8 who reports to userid = 3; and userid = 9 who reports to userid = 8 as shown below …

Member Avatar
Member Avatar
+0 forum 4

Hello all members, I am new to this this website. I am working on an assignment and I have a scenario where I have to find the key attributes, entities and keys. Below is the scenario, An international courier, express and parcel Services Company is setting up a package shipping system for customers to ship packages. Whenever a customer wishes to ship a package, they can call the company‚Äôs customer service personnel to place a shipment request. A computer system is needed to track the shipment details of the package. This will enable the company to keep track of their …

Member Avatar
Member Avatar
+0 forum 3

I want to see the penalties updating, but it's only see after you click the return button and wait for one day again that it will show the penalty. <?php $user_query=mysqli_query($dbcon, "select * from borrow LEFT JOIN member ON borrow.member_id = member.member_id LEFT JOIN borrowdetails ON borrow.borrow_id = borrowdetails.borrow_id LEFT JOIN book on borrowdetails.book_id = book.book_id ORDER BY borrow.borrow_id DESC ")or die(mysqli_error()); while($row=mysqli_fetch_array($user_query)){ /* ---- This code below ---- */ $borrowdate = new Datetime($row['due_date']); $currentdate = new Datetime(); $returndate = new Datetime($row['date_return']); $fines = 0; if($currentdate > $returndate){ $days = $borrowdate->diff($returndate ?: $currentdate, true)->days; $fines = $days > 0 ? …

Member Avatar
Member Avatar
+0 forum 1

HI,everyone , I m stum in this question for long time, could somebody help me out, my output is success ,but the arrange in table is wrong. below is my code.. <?php $no_pensyarah=$_SESSION['no_pengguna']; $tahunsemasa =date('Y'); include '../includes/dbconnect.php'; $sql_rekod = "SELECT a.*,b.nama_subjek,c.nama_kursus FROM info_subjek_pensyarah as a, subjek as b,kursus as c WHERE a.kod_subjek = b.kod_subjek AND a.kod_kursus = c.kod_kursus AND tahun_bahagian LIKE '$tahunsemasa%' AND no_pensyarah = '$no_pensyarah'"; $result_rekod = mysql_query($sql_rekod) or die('Query failed. ' . mysql_error()); $tmpCount = 1; while($row = mysql_fetch_assoc($result_rekod)) {?> <?php $nama_kelas = $row['nama_kelas']; ?> <tr> <td><?php echo $tmpCount; ?></td> <td><?php echo $row['kod_kursus']; ?></td> <td><?php echo $row['nama_kursus']; ?></td> …

Member Avatar
Member Avatar
+0 forum 1

I have a table with nutrient data(in Dutch) it looks like this ![Nutrient_table.png](/attachments/small/1/ea03b9085fe045894414a3101f2d6b4b.png "align-left") 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 one table? Thanks in advance for any answer.

Member Avatar
Member Avatar
+0 forum 6

As I am doing a application on attendance management where I need to store the details by using check boxes I am unable to store the details of check boxes where it will be generated as present or absent in database Can anyone help me to find out this

Member Avatar
Member Avatar
+0 forum 4

Hi Everyone, Can anybody suggest me. I have mysql with two database operations and production. My operations db have master master syncing on live server . I want to make production's master slave syncing onsame live server . Is it possible. How can do it?. Please help me. Thanks in advance

Member Avatar
+0 forum 0

Hello all, I am stuck at some logic and can't able to find stuffs for my research.I have a web based data Entry app in php.Now there will be atleast 2 operators for data entry.now when they login they will redirected to same page.I fetch one file at a time.Here is couple of things I am confused 1.Both Operators see same files when they are redirected to their page[ as records are fetched sequentially from in increasing oreder pf primary key in database ].how can i show different files to users? 2.let's assume they look same file they can do …

Member Avatar
Member Avatar
+0 forum 5

it means if user insert "n"(number of case) in textbox than click the "Next" button, in datagridview set to "n" number of rows. i don't know what code i use, please help me, please check attach file, thank you so much

Member Avatar
Member Avatar
+0 forum 9

Am trying to create edit-form but there are some problem which I cant determine by my self. I cant echo inserted record and updating. <?php include("db_con.php"); $edit_reg_no = filter_input(INPUT_GET, 'edit_customer_detail', FILTER_VALIDATE_INT, ['options' => ['default' => NULL]]); if(isset($_POST['update'])){ $update_reg_no = $edit_reg_no; //getting the text data from the fields $d_fname = $_POST["d_fname"]; $d_lname = $_POST["d_lname"]; $customer_name = $_POST["customer_name"]; $mobile = $_POST["mobile"]; $office_tel = $_POST["office_tel"]; $email_fax = $_POST["email_fax"]; $model = $_POST["model"]; $engine = $_POST["engine"]; $vin = $_POST["vin"]; $work_carry = $_POST["work_carry"]; $demage_found = $_POST["demage_found"]; $accessories = $_POST["accessories"]; $car_received = $_POST["car_received"]; $mileage_covered = $_POST["mileage_covered"]; $update = "update customer_details set d_fname='$d_fname', d_lname='$d_lname', customer_name='$customer_name', mobile='$mobile', office_tel='$office_tel', email_fax='$email_fax', …

Member Avatar
Member Avatar
+0 forum 3

I am currently developing in Visual Studio 2008 (Visual Basic) and I have no problem reading, editing, saving, etc. to a 2007 Access database that is stored locally using the following code: [CODE]Dim NotifyDS As New DataSet() Dim NotifyCon As New OleDb.OleDbConnection NotifyCon.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Data\Settings.accdb" NotifyCon.Open()[/CODE] Ultimately I am going to be installing this program in my office on multiple computers, but would only like to have one "server" program where the database is installed. All of the other computers will have access to this one database over the LAN. For some reason I am unable to access this …

Member Avatar
Member Avatar
+0 forum 14

A new client, as you know client have sometime zero knowledge related to web development. Client said to insert a link in her website. But when I asked her for login details she provide me godaddy login details. When I loged in there, I saw this: [Image](http://ibb.co/kYGP7a) There is no web hosting for her website on godaddy. So how to find on which server she is hosting her site.

Member Avatar
Member Avatar
+0 forum 6

Hi not sure if this is possible so wanted some guidance.. I have a database with 3 columns.. id, data,timestamp id is auto increment and data is json array and timestamp is unix timestamp.. the field I wanted to update was data but I wanted to replace just a part of it.. see sample data below (id, data, timestamp) (1, '{"Employee_Number":"235","First_Name":"Test","Middle_Name":"TEST2"}',1495120538) I wanted to replace the 235 with 544 but I will not know what data there is in the data field .. I will only know the id I tried UPDATE `table` SET `data`= replace(data, '{"Employee_Number":"%","First_Name"', '{"Employee_Number":"544","First_Name"') WHERE `id` …

Member Avatar
Member Avatar
+0 forum 3

Good day, I having a problem where creating my setting table as condition below column User_id setting effective_date effective_end_date Row 1: 1 ABC 2017-03-01 2018-02-28 Row 2: 1 DEF 2018-03-01 2019-03-01 I wish to add a constraint to block if same user add in a setting with the effective_date or effective_end_date between existing setting. Is that posible? I had searching and trying for a few days now without succeed to archive what I trying to do. Please kindly guide me through this. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 1

i can't get DateTimePicker to insert into Access databse. I've tried all the suggestion i can find from this forum, so i'm thinking my problem is different? my table has a column date which has a Date/Time format my code [CODE] Dim cmd As OleDbCommand Dim sqlstr As String, ans As Boolean Dim mydate As DateTime mydate = Me.dtPickerT.Value sqlstr = "INSERT INTO table(date) VALUES (" & mydate & ")" cmd = New OleDbCommand(sqlstr, con) ans = cmd.ExecuteNonQuery() If (ans = True) Then 'message added MsgBox("success") Else MsgBox("not entered") '' error End If cmd = Nothing [/CODE] error message is: …

Member Avatar
Member Avatar
+0 forum 6

The End.