Member Avatar
My client is wanting a 'simple' stock update system in MS Access. I have a form and subform (which is a packing slip) where the user will select the style of shoe eg ASHE_Choc and then enter the number of stock wanted for each size eg 5 for size 6_40. …
by Bronwyn_1 in Software Development ()
Member Avatar
/DROP TABLE STATEMENTS/ DROP TABLE BRANCH CASCADE CONSTRAINT PURGE; DROP TABLE SCREEN CASCADE CONSTRAINT PURGE; DROP TABLE SESSIONS CASCADE CONSTRAINT PURGE; DROP TABLE MOVIE CASCADE CONSTRAINT PURGE; /CREATE TABLE STATEMENT/ CREATE TABLE BRANCH( BRANCHID CHAR(2)NOT NULL, BRANCHNAME VARCHAR2(20), BRANCHSUBURB VARCHAR2(15), BRANCHPOSTCODE CHAR(4), CONSTRAINT BRANCH_PK PRIMARY KEY(BRANCHID)); CREATE TABLE SCREEN( SCREENID …
by nathan_8 in Databases ()
Member Avatar
Good afternoon, Currently, I’m trying to consolidate all my financial information into one place so that I can see (the solution I’m currently using is Excel – see attached): 1. Valuation at a particular date 2 .Breakdown by investment product 3. Various other analytics (Allocation by class etc.) I’ve tried …
by ShortYute in Databases ()
Member Avatar
Hi, I am new to this concept. How to export data from database in EXCEL for various standards with "dynamic headings" .
by AntonyRayan 15 in Web Development ()
Member Avatar
I have been trying to insert,update,delete,select with separate queries.But when i try to write a query after a pre-written query i get an error that the string is predefined.I am working on a PBL project so i have to show all that in one program itself. Here is the current …
by sumod in Databases ()
Member Avatar
Hi guys you might know this about qr code im just a newbie here, my problem is that i can't produce simple qrcode that will fetch the data through the database , i wanted to create a single row of database and display it as a qrcode, can you help …
by rheiniel in Web Development ()
Member Avatar
Hello i have a question about the security of my website, does my website can get hacked somehow if im updating it directly from my database? (ex. images, posts, links...). I have few pages on my website which have PHP code to read info from the database and i do …
by Stefan_1 -3 in Web Development ()
Member Avatar
Hi, i'm trying to enable users to upload to my db. at the moment i've just got a folder called 'uploads' in my root directory... (i'll worry about getting them into the db once i can uplaod to there!) here's my php... <?php $target_dir = "http://www.XXXXXX.com/uploads/"; $target_file = $target_dir . …
by Andy_10 in Web Development ()
Member Avatar
Hello, I am trying to save the date field into mysql table. The date field in my jsp form is in format MM/DD/YYY and in database as YYYY/MM/DD. How can I retrieve the date from form and insert into the table with YYYY/MM/DD format ?
by Sushmitha_1 in Web Development ()
Member Avatar
hi all , Am doing event management project. In jsp page am using javascript date picker. Then i passed that to servlet page by the following code. DateFormat formatter ; formatter = new SimpleDateFormat("dd-MM-yyyy"); Date date=formatter.parse(request.getParameter("date")); now I want to insert date in mysql database , How can I achieve …
by anand01 in Web Development ()
Member Avatar
Create Table Non_Game ( P_Id int Not_Null, Item_Num Char(4) Not Null, Description Char(30), On_Hand Decimal(4,0) Category Char(3) Price Decimal(6,2), ))
by Drew-Shawn in Databases ()
Member Avatar
My Error info isnt being clear enough for me to understand the problemIs there anything worng here so i can continue on lookng for the probelm: $sql = "INSERT INTO boards ( title, genre, creator, tagline, intro, remessage, visability, recruitment, reqsheet, reqdice, reqgroup, ppweek) VALUES ( $title, $genre, $creator, ". …
by CreatorZeus in Web Development ()
Member Avatar
Hello, I have two tables in mysql using php> 1) Consumers 2) Monthly Billing In Consumers that table contains about 100s of Consumers , and it increase monthly. 2) Monthly Billing for Billing. What i want to do ? Is there are any way that i can generate monthly billing …
by spluskhan -2 in Web Development ()
Member Avatar
Dear Developers, This is the part of my blog.While adding new post to my blog the category option not updating to database add_post.php <h2>Add Post</h2> <?php //if form has been submitted process it if(isset($_POST['submit'])){ $_POST = array_map( 'stripslashes', $_POST ); //collect form data extract($_POST); //very basic validation if($postTitle ==''){ $error[] …
by Faisal_13 in Web Development ()
Member Avatar
Hi. I have tried to save the Json data retrieved below in vain. When I connect the database and try to insert the post data, the script no longer retrieves or decodes the data. When I leave it, the API tells me the data was reconciled or decoded. How can …
by Eddy_1 in Web Development ()
Member Avatar
How can I convert (move) individual HTML webpages in bulk into mysql forum? What I have is just the 1000s of html pages which consist of question and answers. Now how can I move then into into mysql forum. This is how my question/answer html pages looks like this:- drive.google.com/file/d/0B4RFn3PmjNy9YTNkbE5mejBfV1U/view?usp=sharing …
by Mani_7 in Web Development ()
Member Avatar
I am creating one application visual basic and sqlce I have two forms name Form1 and Form2. I used Form1 to add data to database using OLeDb command and used Form2 to show data in datagridview by using dataset I used following code: FFORM1 CODE is as following [code] Private …
by jazzyb in Software Development ()
Member Avatar
Dear all I am a beginner in web development. Please help to resolve the below problem. Right now I am creating a Workers Directory with sql database. This is including worker name, Location, Work and mobile numbers. > When customer select the specific job we need to filter particular job …
by Faisal_13 in Web Development ()
Member Avatar
Dear devolepers, I have problem with my sql database, I want acces my sql database in my <LI> list plaese help to resolve this problem Here is my html sql database : my_db table : info_list Table columns : id,name,job,town,mobile1,mobile2,phone,adress i want to display town list in this <li> list …
by Faisal_13 in Web Development ()
Member Avatar
Hello. I am new to PHP/MYSQL. My array looks like this: Array ( [1] => item1 [2] => 1tem2 [3] => item3 [4] => item4 [5] => item5 [6] => item6 ) Array ( [7] => item1 [8] => item2 ) Array ( [9] => item1 [10] => 1tem2 [11] …
by Gurjit_2 in Web Development ()
Member Avatar
Dear developers How to show contact details while clicking the particular name from <li> list Contact_list.php <?php $con=mysqli_connect("localhost","user","pass","nilambu1_mydb"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result = mysqli_query($con,"SELECT * FROM n_info "); while($row = mysqli_fetch_array($result)) { echo "<li><a href='contact.php' data-transition='slidedown'> <img …
by Faisal_13 in Web Development ()
Member Avatar
Hi! Having a hard time figuring out how to solve this problem at hand. basically i have several tables that are inter connected in some manners but i need to full all this data and format it in a manner that it will show the total number of trips and …
by skullscript in Web Development ()
Member Avatar
Hello, i am a new php and html developer. kindly assist me for my querys thanks in advance raj
by Raj_18 in Web Development ()
Member Avatar
I am banging my head again, and appologise if such a qestion has been posted and answered - i searched and could not see any results matching my question. I have a datagridview1 full of data, one column has a date and another a qty. datagridview1 Date Qty 2015-11-05 | …
by Oxley_1 in Databases ()
Member Avatar
Customers pick When finished If on the book, such as the selection of Van Dyke VT01 from 1/07/59 - 2/07/59-day period, you will not be able to book your car again. It is based on the availability of the vehicle. I made a separate table Storage booking Van table separately …
by Goddy_1 in Web Development ()
Member Avatar
Hi group, I've looked all over the internet to find my solution without luck. Hopefully you can help. I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" …
by doncwilson_1 16 in Databases ()
Member Avatar
sir can you help us or give us an idea in our System Tutorial (Thesis) in our subjet Software Enginieering, our professor required us to make a system that is not yet existed, Examples Grading system, Inventory System, Using VIsual basic 10 with the connection of data base, . sir …
by _1_36 in Databases ()
Member Avatar
I am working on projects in Visual Studio 2015 using the ASP.Net Identity with Entity framework. Entity Framework creates tables in embedded SQL Compact, when the first user is created. My question is: When comes time to roll out into a "live" environment (i.e. Dev, Test or Prod), is there …
by Greg_10 in Web Development ()
Member Avatar
How to retrieve data from another database using PHP, mySQL?
by AntonyRayan 15 in Web Development ()
Member Avatar
Hello everybody, so, I realized that when I try to load some XML into a MySQL table through the `LOAD XML LOCAL INFILE ...` statement, if there is a parent with the same name of the child, MySQL will insert an extra row. Here's the example to reproduce the issue: …
by cereal 1,080 in Databases ()