tjc0ol
Last Activity: Nov 12 '08, 04:12 AM
Joined: Nov 6 '07
Location:
-
tjc0ol replied to 1054 - Unknown column 'p.products_id' in 'on clause' select p.products_image, pd.proin PHPthanks man for the great help to me. I already corrected it. More power to all of you guys. ;o) -
tjc0ol started a topic 1054 - Unknown column 'p.products_id' in 'on clause' select p.products_image, pd.proin PHP1054 - Unknown column 'p.products_id' in 'on clause' select p.products_image, pd.pro
Hi guys,
I'm a newbie in php and I got error in my index.php which is:
1054 - Unknown column 'p.products_id' in 'on clause'
select p.products_imag e, pd.products_nam e, p.products_id, p.manufacturers _id, p.products_pric e, p.products_tax_ class_id, IF(s.status, s.specials_new_ products_price, NULL) as specials_new_pr oducts_price, IF(s.status, s.specials_new_ products_price, p.products_pric e) as final_price... -
Thanks for replying guys and for the time.. Actually it is provided by our shopping cart host - it is only a javascript link and I just figured out why it can't be validate because of the "&" which needs to be converted first in & then validate. -tjLeave a comment:
-
Remote Price javascript code needs to be translated
Hi guys,
Can this remote price javascript code below:
be translated as follows?Code:<script type="text/javascript" language="javascript" src="http://www.remoteprice.com/data.asp?storeid=00000&itemcode=00420701089&type=1"></script>
...Code:<script type="text/javascript" language="javascript"> <!--// ....
-
Thanks for the reply and for sharing your knowledge to us all. -tj...Leave a comment:
-
Two Images changed when link is clicked
Hi guys,
I have here a javascript code that is capable of changing one background image when link is clicked, it goes:
...Code:<script type="text/javascript" language="javascript"> var bgImg = new Array(); bgImg[0] = "images/backpink.jpg"; bgImg[1] = "images/backgreen.jpg"; bgImg[2] = "images/backvoilet.jpg"; bgImg[3] = "images/backblue.jpg";
-
thanks a lot this one solves the problem....Leave a comment:
-
There is a code inside the block
...Code:void Page_Load() { if (IsPostBack) { dgEmployees.DataSource = GetEmployees(); dgEmployees.DataBind(); } } DataView GetEmployees() { DataSet objDS = new DataSet(); OleDbConnection objConn = new OleDbConnection(ConfigurationSettings.AppSettings["DSN"]); OleDbDataAdapter objDA; objDV = (DataView)Cache["Employees"];Leave a comment:
-
Dr B,
I think yes, as according to my code I placed theinside theCode:dgEmployees.DataSource = GetEmployees();
There is a binding of data to the DataGrid inside theCode:if(IsPostBack) {...Code:DataView GetEmployees() { DataSet objDS = new DataSet(); OleDbConnection objConn = new OleDbConnection(ConfigurationSettings.AppSettings["DSN"]); OleDbDataAdapter objDA; objDV = (DataView)Cache["Employees"];Leave a comment:
-
In Firefox when you clicked on the others in <select> there's no pop-up will show.
By the way I tried your code above and it won't work. Anyways thanks for the infos. -tj...Leave a comment:
-
Thanks a lot, I tried this one and it work. -tj...Leave a comment:
-
Hi Again,
here's my ASP.NET version below:
Version Information: Microsoft .NET Framework Version:2.0.507 27.1433; ASP.NET Version:2.0.507 27.1433...Leave a comment:
-
Adding javascript to select element won't work on Firefox browser.
Hi all,
I made contact page which allows visitors to input their name, email address, phone number, comments and select a comment type by using <select> element in html with javascript. Among the option of it are: General Support, Technical Support, Sales in billing, Request RA no. and Others. If they select Others there will be a pop-up textbox for others(so they can specify a comment type) and the textbox is placed on a DIV. I placed... -
Anyways I found it out my asp.NET version:
VersionCheck results for my machine:
Installed .NET Runtime(s)
OK.
Current version: The following runtimes are installed:
1.1.4322.2407 Version 1.1 Post-SP1 with KB928366 Apr 2007
2.0.50727.1433
3.0.4506.30 Version 3.0 RTM (RTM 4506.30) Nov 2006
ADO Database Runtime Version
OK.
Current version: 2.81.1132.0
Determined...Leave a comment:
-
Honestly I don't know how to check my asp.NET version, all I know is that I'm using Expression web on my aspx pages. My other aspx example pages runs smoothly but this example above doesn't.
Yes it was saved as an aspx page.
I think its in .NET Framework 1.1(version 1.1.4322.573) since I can't find any IIS server here. I can't find it in Administrative tools.
Here's my previous aspx example below that...Leave a comment:
-
No display when previewed
Hi guys,
I'm an .NET newbie, I need help.
Why is it that when I preview my aspx page it won't show up anything except this line:
<p>The data will be refreshed 10 seconds from now: <%= DateTime.Now %></p>
Here's my code below:
...Code:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-
A million thanks ;-)Leave a comment:
-
Cannot Update Database through DataGrid & DataList Control
Hi guys,
Im just wondering that I cannot update my database throught datagrid datalist control, and the only thing works is that I can delete, cancel, edit but when I clicked update link there's an error that says: "Syntax error in UPDATE statement."
I wonder what's wrong with my code and how to correct this one?
Below are my codes:
...Code:OleDbConnection objConn = new OleDbConnection(
-
thanks guys, I was a relationship error, I set it mistakenly in MS Access. ;-)Leave a comment:
-
Inserting Record to MS Access
Hi guys,
Im a newbie in .NET, I follow the book in SitePoint which is Building your own ASP.NET Website using C# but I'm having trouble in inserting new data to MS ACCESS. When I run it, I've got an error i.e. You cannot add or change a record because a related record is required in table 'HelpDeskCatego ries'.
How to correct this error and How to insert new record to MS Access without experiencing error?
Here is my code:...
No activity results to display
Leave a comment: