Web Development

in XSLT - need to go to the folder when click

24-Jun-12 10:07

Here, have a look at these:
Load Data while Scrolling Page Down with jQuery and PHP[^]
Load Data while Scrolling Page Down with jQuery and PHP - 2[^]

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

Clickable link in XSLT

Member 915222021-Jun-12 4:48

Member 9152220

21-Jun-12 4:48

XML

I have follwoing code.
I have 2 variables in the XML file that I am reading here, Item no and name.

Then I created a folder item_Name in the 3rd column of the page so that when I click it it should take me to the folder.

The file is in the root folder.

Can someone let me know whats wrong with following cell

<td>
    <div>
    <a href=&#34;{&URL1}&#95;{&URL2}&#34;><xsl&#58;value-of select=&#34;Folder&#34;/></a>

</div></td>


-----------here's the full code -------------------------------------------------



<xsl&#58;stylesheet xmlns&#58;xsl=&#34;http&#58;//www.w3.org/1999/XSL/Transform&#34; version=&#34;1.0&#34;>
<xsl&#58;template match=&#34;/rss&#34;>
<html>
<head>
<title>RSS feed</title>
</head>
<body>
    <table width="100%" cellspacing="0">
        <tr><td><H1><center>Welcome</center></H1></td></tr>
        <tr><td><H2>Click on a column header to sort by each column.</H2></td></tr>
        <tr><td><DIV id="listing"><xsl:apply-templates match="NotesDocuments"/></DIV></td></tr>



    </table>
    </body>
</html>
</xsl&#58;template>

<xsl:template match="NotesDocuments">
    <table STYLE="background-color=beige">
    <thead>
    <td><DIV class="hd" onClick="sort('item no')">no</DIV></td>
    <td><DIV class="hd" onClick="sort(Name')">Name</DIV></td>
    <td><DIV class="hd" onClick="sort('folder')">folder</DIV></td>

    </thead>

    <xsl:for-each select="NotesData" order-by="TITLE">



    <tr>
    <td><DIV class="rw"><xsl:variable name="URL1"><xsl:value-of select="no"/></xsl:variable></DIV></td>
    <td><DIV class="rw"><xsl:variable name="URL2"><xsl:value-of select="Name"/></xsl:variable></DIV></td>

    <td>
    <div>
    <a href=&#34;{&URL1}&#95;{&URL2}&#34;><xsl&#58;value-of select=&#34;Folder&#34;/></a>

</div></td>



    </tr>
    </xsl:for-each>
    </table>

</xsl&#58;stylesheet>

Member 915222021-Jun-12 4:45

Member 9152220

21-Jun-12 4:45

I have follwoing code.
I have 2 variables in the XML file that I am reading here, Item no and name.

Then I created a folder item_Name in the 3rd column of the page so that when I click it it should take me to the folder.

The file is in the root folder.

So I creaTED 2 Variables and concatanated and create an <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="/rss">
<html>
<head>
<title>RSS feed</title>
</head>
<body>
<table width="100%" cellspacing="0">
<tr><td><H1><center>Welcome</center></H1></td></tr>
<tr><td><H2>Click on a column header to sort by each column.</H2></td></tr>
<tr><td><DIV id="listing"><xsl:apply-templates match="NotesDocuments"/></DIV></td></tr>

</table>
</body>
</html>
</xsl:template>

<xsl:template match="NotesDocuments">
<table STYLE="background-color=beige">
<thead>
<td><DIV class="hd" onClick="sort('item no')">no</DIV></td>
<td><DIV class="hd" onClick="sort(Name')">Name</DIV></td>
<td><DIV class="hd" onClick="sort('folder')">folder</DIV></td>

</thead>

<xsl:for-each select="NotesData" order-by="TITLE">

<tr>
<td><DIV class="rw"><xsl:variable name="URL1"><xsl:value-of select="no"/></xsl:variable></DIV></td>
<td><DIV class="rw"><xsl:variable name="URL2"><xsl:value-of select="Name"/></xsl:variable></DIV></td>

<td>
<div>
<a href="{&URL1}_{&URL2}"><xsl:value-of select="Folder"/></a>

</div></td>

</tr>
</xsl:for-each>
</table>

</xsl:stylesheet>

MVC PostBackURL

AghaKhan20-Jun-12 19:52

AghaKhan

20-Jun-12 19:52

I like to submit a request to a web service and wait for the response. I have to give web service a page name where I should the response. <asp:button postbackurl="SomePage"" runat="server"> but I am unable to find any reference to PostBackUrl in MVC. In other word how are we going to deal with PostBackUrl or how we can provide return CallBack page?

Re: MVC PostBackURL

Sandeep Mewara21-Jun-12 17:28

from .dbf FoxPro to MySql

21-Jun-12 17:28

Not clear on what are you trying to ask here. You start by requesting a webservice on one end and then ended up asking postback url in MVC. Please update your question and clearly specify about your work and need.

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

Re: MVC PostBackURL

AghaKhan21-Jun-12 21:19

AghaKhan

21-Jun-12 21:19

XML

Well I send a SMS (message) through a service provider, where server provider is asking me the web address where to inform back for the result as a success or fail.
You may look complete example at (Working example and you play it to understand it)
http://www.w3schools.com/aspnet/showasp.asp?filename=demo_prop_webcontrol_button_postbackurl
 <!DOCTYPE html>
<html>
<body>
<form runat="server">
Name:<asp:textbox id="TextBox1" runat=Server />
<asp:button id="Button1" Text="Submit"
PostBackUrl="demo_postbackurl.aspx" runat="Server" />
</form>
</body>
</html>

As you see asp:button has property PostBackUrl, but as far as I know there is no button implementation under MVC3. The service provider only take web address as a PostBackUrl to return the status of the MSM call.

I hope I explained well. Thank you very much for the reply.

Susy Nainggolan18-Jun-12 18:16

18-Jun-12 18:16

Hi, I have a problem, I don't know how to convert .dbf in FoxPro to MySql using PHP. Who can help me? Smile | :)

enhzflep18-Jun-12 18:58

18-Jun-12 18:58

Gday, I dunno how to do it either.

But Google does! Entering your thread title (only) yielded 84,000 results. Presumably one of the first 10 will suffice?

Here you go: from+.dbf+FoxPro+to+MySql[^]

Susy Nainggolan18-Jun-12 21:00

18-Jun-12 21:00

hehehe..Thanx for your attention before Sir.
I know Sir, I have done it before..
but my code is not give solution..
It can't open the .dbf file..
it's error said that lenght parameter must be greater than 0.
what happen with it?

Thanx before.. Smile | Smile | :)

enhzflep18-Jun-12 21:18

18-Jun-12 21:18

A sense of humour and polite. Nice! Thumbs Up | :thumbsup:

That's enough to get continued effort form me right now.

I don't know "what happen with it?"

Can you show the line of code that fails?

Susy Nainggolan18-Jun-12 22:42

18-Jun-12 22:42

heheheh..thanx Sir..
this is the code Sir..
I don't know where is the wrong code,
because I think it's already right n it have used by another person n when I just try I can't..

sorry if u feel bothered.. Smile | :)

PHP

<?php

class dbf_class {

var $dbf_num_rec; //Number of records in the file
var $dbf_num_field; //Number of columns in each row
var $dbf_names = array(); //Information on each column ['name'],['len'],['type']
//These are private....
var $_raw; //The raw input file
var $_rowsize; //Length of each row
var $_hdrsize; //Length of the header information (offset to 1st record)
var $_memos; //The raw memo file (if there is one).

function dbf_class($filename) {
if (!file_exists($filename)) {
echo "<script>alert('Masukkan data DBF')</script>";
} else {
$handle = fopen($filename, "r");
}
if (!$handle) {
echo "Cannot read DBF file";
}
$filesize = filesize($filename);
$this->_raw = fread($handle, $filesize);
fclose($handle);
//Make sure that we indeed have a dbf file...
// if(!(ord($this->_raw[0]) == 3 || ord($this->_raw[0]) == 131) && ord($this->_raw[$filesize]) != 26) {
// echo 'ukurun tidak tepat !!!'; exit;
// }
// 3= file without DBT memo file; 131 ($83)= file with a DBT.
$arrHeaderHex = array();
for ($i = 0; $i < 32; $i++) {
$arrHeaderHex[$i] = str_pad(dechex(ord($this->_raw[$i])), 2, "0", STR_PAD_LEFT);
}
//Initial information
$line = 32; //Header Size
//Number of records
$this->dbf_num_rec = hexdec($arrHeaderHex[7] . $arrHeaderHex[6] . $arrHeaderHex[5] . $arrHeaderHex[4]);
$this->_hdrsize = hexdec($arrHeaderHex[9] . $arrHeaderHex[8]); //Header Size+Field Descriptor
//Number of fields
$this->_rowsize = hexdec($arrHeaderHex[11] . $arrHeaderHex[10]);
$this->dbf_num_field = floor(($this->_hdrsize - $line ) / $line); //Number of Fields
//Field properties retrieval looping
for ($j = 0; $j < $this->dbf_num_field; $j++) {
$name = '';
$beg = $j * $line + $line;
for ($k = $beg; $k < $beg + 11; $k++) {
if (ord($this->_raw[$k]) != 0) {
$name .= $this->_raw[$k];
}
}
$this->dbf_names[$j]['name'] = $name; //Name of the Field
$this->dbf_names[$j]['len'] = ord($this->_raw[$beg + 16]); //Length of the field
$this->dbf_names[$j]['type'] = $this->_raw[$beg + 11];
}
if (ord($this->_raw[0]) == 131) { //See if this has a memo file with it...
//Read the File
$tail = substr($tail, -1, 1); //Get the last character...
if ($tail == 'F') { //See if upper or lower case
$tail = 'T'; //Keep the case the same
} else {
$tail = 't';
}
$memoname = substr($filename, 0, strlen($filename) - 1) . $tail;
$handle = fopen($memoname, "r");
if (!$handle) {
echo "Cannot read DBT file";
exit;
}
$filesize = filesize($memoname);
$this->_memos = fread($handle, $filesize);
fclose($handle);
}
}

function getRow($recnum) {
$memoeot = chr(26) . chr(26);
$rawrow = substr($this->_raw, $recnum * $this->_rowsize + $this->_hdrsize, $this->_rowsize);
$rowrecs = array();
$beg = 1;
if (ord($rawrow[0]) == 42) {
return false; //Record is deleted
}
for ($i = 0; $i < $this->dbf_num_field; $i++) {
$col = trim(substr($rawrow, $beg, $this->dbf_names[$i]['len']));
if ($this->dbf_names[$i]['type'] != 'M') {
$rowrecs[] = $col;
} else {
$memobeg = $col * 512; //Find start of the memo block (0=header so it works)
$memoend = strpos($this->_memos, $memoeot, $memobeg); //Find the end of the memo
$rowrecs[] = substr($this->_memos, $memobeg, $memoend - $memobeg);
}$beg+=$this->dbf_names[$i]['len'];
}
return $rowrecs;
}

function getRowAssoc($recnum) {
$rawrow = substr($this->_raw, $recnum * $this->_rowsize + $this->_hdrsize, $this->_rowsize);
$rowrecs = array();
$beg = 1;
if (ord($rawrow[0]) == 42) {
return false; //Record is deleted...
}
for ($i = 0; $i < $this->dbf_num_field; $i++) {
$col = trim(substr($rawrow, $beg, $this->dbf_names[$i]['len']));
if ($this->dbf_names[$i]['type'] != 'M') {
$rowrecs[$this->dbf_names[$i]['name']] = $col;
} else {
$memobeg = $col * 512; //Find start of the memo block (0=header so it works)
$memoend = strpos($this->_memos, $memoeot, $memobeg); //Find the end of the memo
$rowrecs[$this->dbf_names[$i]['name']] = substr($this->_memos, $memobeg, $memoend - $memobeg);
}
$beg+=$this->dbf_names[$i]['len'];
}
return $rowrecs;
}

}

?>

enhzflep18-Jun-12 23:37

18-Jun-12 23:37

Hmmm. Okay - that was actually the class I was going to recommend you use.

Now then, the text "length" appears in that document 3 times - each of these are in the comments.

I also see that it doesn't include any other php files, so I can only deduce that the error message is coming from MySql itself. Its very difficult to tell, since you didn't copy/paste the exact error message. (I doubt the error message is going to spell 'length' as 'lenght' Poke tongue | ;-P

)

This makes me consider the possibility that there is in fact, nothing wrong with this code, and that the problem lies in the database structure.

Another alternative is that (& I don't know) perhaps the FoxPro database has a field with NULL in it and you're trying to insert that, but since there's no value, an empty parameter is being passed to mysql, rather than a zero or NULL value..

However, since the code has been around for so long, (at least since 2004) it seems unlikely that it still has an error.

I see that you've made this modification:

PHP

if (!file_exists($filename)) {
echo "<script>alert('Masukkan data DBF')</script>";
}

In the original code, there is an exit statement in that block, so that execution wont continue if there's a problem. In your case, it does! (continue if there's a problem)
I'd change that quick-smart!

PHP

if (!file_exists($filename)) 
{
        echo 'Masukkan data DBF'"
        exit;
}

I suggest that you add some more printf/echo statements to the class to let you know when execution passes certain arbitrary points. A good first location would be after the file has been read and then closed.

At least then you can know where processing gets to before failure - this lets you know which data is being processed at this point and dismiss or confirm that it's the data.

But in any case, often a quick way is to add more echo statements so you know where execution fails.

Good luck. Thumbs Up | :thumbsup:

Susy Nainggolan18-Jun-12 23:46

18-Jun-12 23:46

thanx sir..
Sir, finally this is the error when I browse the file .DBF...

A PHP Error was encountered
Severity: Warning
Message: fopen(DRBS.DBF) [function.fopen]: failed to open stream: No such file or directory
Filename: models/dbf_class.php
Line Number: 18

Cannot read DBF file
A PHP Error was encountered
Severity: Warning
Message: filesize() [function.filesize]: stat failed for DRBS.DBF
Filename: models/dbf_class.php
Line Number: 22

A PHP Error was encountered
Severity: Warning
Message: fread() expects parameter 1 to be resource, boolean given
Filename: models/dbf_class.php
Line Number: 23

A PHP Error was encountered
Severity: Warning
Message: fclose() expects parameter 1 to be resource, boolean given
Filename: models/dbf_class.php
Line Number: 24

enhzflep18-Jun-12 23:57

Re: web service + soap+ xml

18-Jun-12 23:57

Susy Nainggolan wrote:
fopen(DRBS.DBF) [function.fopen]: failed to open stream: No such file or directory

BINGO!

So what's the full path to:

dbf_class.php
DRBS.DBF
The file that creates the instance of the dbf_class

Also, is the cAsE correct for DRBS.DBF?
Is it drbs.dbf perhaps?

web service + soap+ xml

moiamal18-Jun-12 2:52

moiamal

18-Jun-12 2:52

hi
Please I try to retrieve data from web services (soap) and must pass an ID in cookie http header I tried with java code (eclipse) but I can not I tried also with other tools tjrs but its not happening ...
I am beginner I really need a helping hand to find the error and the tool to be used

Thank you in advance

My prob is in the URL: I can not add it and how to add the "sid"on url (sid: is the username (cookie))

Sandeep Mewara18-Jun-12 19:58

Re: web service + soap+ xml

18-Jun-12 19:58

Could you not send it as a query string in the URL?
Sample: http://myserver/mywebsite/mywebservice.asmx?sid=mycookiename

Refer: Passing variables between pages using QueryString[^]

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

Message Closed

19-Jun-12 0:21

moiamal

19-Jun-12 0:21

Message Closed

Rahul Rajat Singh26-Jun-12 0:50

Rahul Rajat Singh

26-Jun-12 0:50

Just a suggestion - please don't post so much of code here. you might be working for some employer and if he finds out that the code is being leaked on public forums you might get in trouble.

Post just the stuff that is causing the problem. always be discreet while giving code. make sure you don't violate the employes NDA in any way. we don't want you to get in trouble.

Every now and then say, "What the Elephant." "What the Elephant" gives you freedom. Freedom brings opportunity. Opportunity makes your future.

Re: web service + soap+ xml

moiamal26-Jun-12 1:17

moiamal

26-Jun-12 1:17

thx for advice Smile | :)

i delet the code

mysql format number

Jassim Rahma18-Jun-12 2:52

Jassim Rahma

18-Jun-12 2:52

Hi,

I want to know how can I format a number like this:

year = 2012
month = 7

it should be:

year = 2012
month = 07

then bill_code = 201207 (as int)

Re: mysql format number

Bernhard Hiller18-Jun-12 4:16

Bernhard Hiller

18-Jun-12 4:16

int bill_code = 100 * year + month;

Help Vadim Segal To Create Contact Us Form For The Website

VadimSegal17-Jun-12 21:40

VadimSegal

17-Jun-12 21:40

Hello Guys,

I, Vadim Segal, is here to discuss my query regarding website Contact Us Page.I have a website developed in PHP. The contact us page of the website display the contact detail , but now I want to modify this page and want to add the contact us form to this page. So that , whenever the visitor enter their query, it can directly come to mail address. Please help me with your valuable advice.

Thanks
Vadim

A .Net ligth-weight REST server framework

CodingBruce16-Jun-12 6:08

CodingBruce

16-Jun-12 6:08

I wrote an article on creating a .Net REST service.

.NET REST service[^]

I hoped to re-write the REST aspects utilizing a .Net restful service open source project. I'm avoiding WCF, as it is counter-REST (light-weight/simple). I am thinking of something fluent, spring-like, convention over configuration. It needs to be robust, handle all the verbs, async, file transfers and auth/security.

I can't find anything at all. Anyone have any leads for a .Net library or Java libraries that could be ported? There may also be an opportunity to start an open source project.

Thanks,

-Bruce

-bruce

Attendance system in asp.net

Ajit001016-Jun-12 1:45

Ajit0010

16-Jun-12 1:45

Hello,

i want to make an attendance system in asp.net i have made two tables
1.attence_record (in which i have attendance record like record_id, date, class, subject)
2.raw_att (in which i have particular date and subject attendance)
record_id is foreign key in rwa_att.

now i want to create a grid view control to get the status of particular student.

i also need a dropdown for filling status. that is the main problem.

Re: Attendance system in asp.net

Sandeep Mewara16-Jun-12 3:09