Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
80% Quality Score
Upvotes Received
4
Posts with Upvotes
4
Upvoting Members
4
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
0 Endorsements
Ranked #2K
~28.4K People Reached
About Me

Studying Business Information Technology in United kingdom

Interests
PHP, Javascript, PL/SQL, Trying to develop web applications
Favorite Tags

44 Posted Topics

Member Avatar for az_ez
Member Avatar for rubberman
0
1K
Member Avatar for SQLpower

Hello, So I basically loaded to 2 keys and I want to verify them after I've signed something with one of them, but I a having difficulties. I am getting verified: false at the end without any error. Can someone please point out the flaw? package fliesigning; import static fliesigning.FlieSigning.verifySig; …

Member Avatar for SQLpower
0
286
Member Avatar for SQLpower

Hello, So I basically created SQL Server Database and I got it working with displaying my images and drop downlist and everything, however, I want to make it to display an image only if a continent is selected. So if I select Europe, I would like to receive a picture …

1
124
Member Avatar for SQLpower

Hello, So shortly I am receiving an SQL Error: ORA-00932: inconsistent datatypes: expected NUMBER got OE.CUST_ADDRESS_TYP 00932. 00000 - "inconsistent datatypes: expected %s got %s" when I am trying to retrieve a part of a string data. SELECT dbms_lob.SUBSTR(cus.cust_address, 0, INSTR(cus.cust_address, ',')-1) AS output FROM oe.customers cus; So basically that's …

0
84
Member Avatar for ravinder yadav

What OS are you using? I used IIS for my ASP.NET app, but I am using Apache for my XBAP application, so it should be possible indeed.

Member Avatar for ravinder yadav
0
2K
Member Avatar for SQLpower

Hello, I created an XBAP web application which I already implemented on my website but I am wondering if it would be possible to pass PHP variables like session etc. to the app itself? I know it's possible with ASP.net, but I am not sure for this one. For example, …

Member Avatar for LastMitch
0
231
Member Avatar for SQLpower

Hello, I have a PHP webpage and I want to pass my session to my XBAP app. I created a cookie. $opts = array('http' => array('header'=> 'Cookie: ' . $_SESSION['FILENAME']."\r\n")); $context = stream_context_create($opts); $contents = file_get_contents("http://localhost/WpfBrowserApplicationUltimate.xbap", false, $context); echo $contents; private void btnAbout_Click(object sender, RoutedEventArgs e) { //MessageBox.Show("RichTextPad. © 2014 …

Member Avatar for Ketsuekiame
0
273
Member Avatar for Yuexuan

That should work: SELECT DISTINCT id, sum(`number`) FROM numbers WHERE `number` >= 1000 UNION SELECT DISTINCT id, `number` AS amount FROM numbers WHERE `number` < 1000 ORDER BY id;

Member Avatar for Yuexuan
0
442
Member Avatar for Thermalnuke

Hello, That sounds to me like a Portable Database Query Analyzer. I wanted to do a Web Database Query Analyzer on my website but eventually just gave up. It was basically going to execute SQL queries from the rich text box editor and give you access to the db. There …

Member Avatar for SQLpower
0
449
Member Avatar for Hazuan Nazri

CREATE TABLE IF NOT EXISTS `maintenance` ( `ID` tinyint(3) NOT NULL AUTO_INCREMENT, `Username` varchar(32) NOT NULL, `Date` date NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; Format the date from the datepicker to the valid data format. Use php's date() function in the controller.

Member Avatar for Hazuan Nazri
0
173
Member Avatar for mogaka

You might wanna set exception handlers for your update statements, in case one of them fail. And for "but when the rows to be affected is more than one,then the stored procedure repeats the updates on the other table-done by stored procedure. You will have to use a "sum" and …

Member Avatar for SQLpower
0
130
Member Avatar for Iggystooge

Well, I suppose you'll be using mySQL, so basically when they enter their details into the form , they will be automatically entered into the database. Then, you will run a query against the database for those fields and data that have been inserted. After that, just save up an …

Member Avatar for iamthwee
0
243
Member Avatar for SQLpower

Would be possible to implement a VB.NET program in a PHP Website? I would want to have a rich text editor for editing files which will be stored in the database and would be displayed on the website. Being able to edit them without leaving the website. I believe would …

Member Avatar for SQLpower
0
236
Member Avatar for SQLpower

Hello. So, I have 2 questions. First is: I am trying to calculate the expiration date which will be calculated as adding the current date + the option that has been select i.e. 30, 60 or 90 days. $EXday = date('d', mktime(0,0,0,0, date(d) + $_POST[exdays], 0)); $EXmonth = date('m', mktime(0,0,0, …

Member Avatar for SQLpower
0
256
Member Avatar for SQLpower

Hello guys, Long story short, when I register a user on my website, it enters for every single column value 0. It should be due to the fact that's not picking up the data from my registration page? Although, it should be ok as I am only picking up the …

Member Avatar for SQLpower
0
195
Member Avatar for SQLpower

Hello, I have a datagridview, where I can edit only 1 field, howerver, I cannot type "4,556" because I restricted it to only number, and if I type 0345, or "0,345" it will just save it as 345. `<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("AMOUNT") %>' BackColor = "#FF960C" MaxLength="4" onChange="intOnly(this);" onKeyUp="intOnly(this);" …

Member Avatar for SQLpower
0
296
Member Avatar for ganges

If you wanna fetch and check through the duplicates, you'd gotta use a cursor.

Member Avatar for adam_k
0
187
Member Avatar for SQLpower

Hello guys, I am still encountering a problem regarding my combobox. I am trying to populate it from my MySQL table but I am unable to so far.... Dim connectionstring As String Dim dbCon As MySqlConnection Dim strQuery As String = "" Dim SQLCmd As MySqlCommand Dim DR As MySqlDataReader …

Member Avatar for TnTinMN
0
222
Member Avatar for SQLpower

Hello, I have a datagridview, connected to my database using Nhibernate and my question is how can I exit the Select Mode after I update? Cause at the moment after I click update and it updates, the edit mode is still on, I would wanna turn it off when I …

Member Avatar for SQLpower
0
549
Member Avatar for SQLpower

Hello. I am trying to connect my MYSQL Database to my JpGraph but it is not working. Any help is appriciated. Here is my conde. <?php include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/src/jpgraph.php"); include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/src/jpgraph_bar.php"); include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/src/jpgraph_line.php"); include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/src/jpgraph_pie.php"); include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/src/jpgraph_pie3d.php"); include ("c:/wamp/www/Charts/jpgraph-3.5.0b1/db.inc"); $host = "localhost"; $username = "root"; $password = ""; $database = "test"; …

Member Avatar for LastMitch
0
2K
Member Avatar for SQLpower

Hello guys, I am trying to dynamically update a combobox using mysql database, however I get the Error Catch Message. Any help would appriciated. Private Sub cmbName_DropDown(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbName.DropDown Try dbCon = New MySqlConnection("SERVER=localhost;DATABASE=test;") strQuery = "Select name from customer_details" cmbName.Items.Clear() If DR.HasRows …

Member Avatar for SQLpower
0
189
Member Avatar for onlykl

netstat -aon |find ":80" or netstat -o -n -a | findstr 0.0:80 in the cmd prompt. taskkill /pid 9999 You can even use the tool from Wampserver to determine if the port is being used. I am sure you can get the source code from somewhere. If you love port …

Member Avatar for SQLpower
0
133
Member Avatar for SQLpower

My Insert statement is not working for some reason and I cannot figure out why. Any help would be highly appriciated. Imports MySql.Data Imports MySql.Data.MySqlClient Public Class frmCreateUser Dim connectionstring As String Dim dbCon As MySqlConnection Dim strQuery As String = "" Dim SQLCmd As MySqlCommand Dim DR As MySqlDataReader …

Member Avatar for SQLpower
0
271
Member Avatar for SQLpower

Hello, I was wondering how could I display around 10 rows vertically and 34 horizontally in a table view with ticks? Every row will have a tick, which upon saving will be added to the database. Any suggestions are highly appreciated!

Member Avatar for SQLpower
0
242
Member Avatar for subhadeep.majumdar.733

14. $get = "SELECT * FROM user WHERE username='$use'"; 15.$set = mysql_query($get); 16.$row = mysql_num_rows($set); 17.if($row == 1) Store it in a $_SESSION, otherwise I don't think it's being fired. if(mysql_num_rows($result)==0) { echo "ERROR - No mactching rows from the database!<br/>"; } else { $_SESSION['ADMIN'] = $_POST["admin"]; } Then you …

Member Avatar for subhadeep.majumdar.733
0
191
Member Avatar for sujimon

Are you talking about changint the system Environment Variables? This is how your TNSNAMES.ora file should look like: http://www.oracle-base.com/articles/misc/oracle-network-configuration.php

Member Avatar for SQLpower
0
313
Member Avatar for Narasinhareddy

I believe they want to create an application similar to facebook, a web application, I assume, no?

Member Avatar for SQLpower
0
65
Member Avatar for SQLpower

Hello all, basically I would want to select a specific field and update it. However when I click Update, I would want to see the data that I selected not just a blank field. I am using a View( I joined 2 tables), so is it possible to update the …

Member Avatar for SQLpower
0
143
Member Avatar for Silverion
Member Avatar for Madriganoh
Member Avatar for samidha

As Fobos suggested use xampp or wamp server. Using wamp you can always check if your port 80 is open.

Member Avatar for SQLpower
0
89
Member Avatar for mortyBox

Well, first, close your connect to the database at the end of the script [CODE] mysql_close($con);[/CODE] Second, use \ when echoing html and you have additional double quotes. example: [CODE] echo " <form id=\"form1\" method=\"post\" action=\"fetch.php\"><tr>"; [/CODE] Otherwise it's not gonna work. Finally, i think you got this one, when …

Member Avatar for SQLpower
0
9K
Member Avatar for SQLpower

Hello, folks. I got another problem. Basically, I wanna check if someone is old enough to watch a movie. I got 2 sessions - one for the certificate( 12, 15, 18) and 1 for the year of birth. My question is can i use somtehing similiar to this or? Cause …

Member Avatar for nidayaqoob1230
0
197
Member Avatar for darkiel21

Hi, well, just by looking at it, you will need to ECHO out everything, including the form as well. You cannot end with [CODE] </html>"; [/CODE] without echo and please use CODE tags.

Member Avatar for karthik_ppts
0
665
Member Avatar for SQLpower

Basically I need some serious help on this one, last one. I am really confused. How can I get my yearofbirth, month of birth and day of birth from my login page, with only having Username/Password as login?? Just basically, creating a [CODE] $_SESSION = ['age'] = The age of …

Member Avatar for simplypixie
0
315
Member Avatar for SQLpower

For example, I have a form that passes the username, the year of birth and the password. Is there anyway I can retrieve information from the database(using an SQL query) if the user is an admin and then convert it to a $_SESSION['admin'];? How can I retrieve additional information about …

Member Avatar for SQLpower
0
2K
Member Avatar for SQLpower

Hello, folks. I do have another issue here, haha. My Cancel script is not working, is not returning the tickets back to the database after I cancel them. I got completely wrong here, some help would be really appreciated. [CODE] <?php session_start(); $tickets = ['tickets']; //$tickets = $_SESSION['tickets']; //$id = …

Member Avatar for Biiim
0
2K
Member Avatar for SQLpower

Hello, folks. I am facing a really annoying problem here. Well, basically I want my page to check if the user is an admin or not. Whenever I log in and try to access that page i am recieving the error message "You are not admin, leave" [CODE] <?php session_start(); …

Member Avatar for bibiki
0
235
Member Avatar for gilgil2

Yo, I got the same problem a couple weeks ago. Add this [CODE] error_reporting(E_ALL ^ E_NOTICE); [/CODE] Just bellow your session_start(); It should work like a charm.

Member Avatar for NinjaMediaD
0
174
Member Avatar for SQLpower

Hello, folks. Well, I can't get my head around that particular function. I want to calculate and then return the total amount of hours assigned for a given stage_no. I got confused. Do I have to use COUNT(*)? [CODE]CREATE OR REPLACE FUNCTION total_numbers_hours(hours NUMBER, stage_no NUMBER) RETURN NUMBER IS return_val …

Member Avatar for SQLpower
0
223
Member Avatar for davy_yg

Did you connect to a database? [CODE] $conn = mysql_connect("localhost", "root", "root"); mysql_select_db("example") or die (mysql_error()); [/CODE] If you don't connect to a database, you won't be able to store your information.

Member Avatar for davy_yg
0
252
Member Avatar for albo1125

You don't need to login to the database to run your script. However, your Apache server must be on.

Member Avatar for SQLpower
0
124
Member Avatar for SQLpower

Hello, guys. I found useful stuff so far. I'd like to ask if someone can give me some ideas how to wandering guards or set switches to open certain doors in a maze game in c++? At the moment I am thinking just to add some bits, can someone give …

Member Avatar for iamthwee
0
320
Member Avatar for SQLpower

Hello. I have some problems understanding the code. I'd like to ask for some help. I need someone to break it down for me. Just to explain what's going on and what's happening. Well this is map.cpp: I got the other bits but I am struggling with this one and …

Member Avatar for Sky Diploma
0
205

The End.