fmwebschool.com
Top Experts [learn more]Top 4-10
webko

9743 K
bandmandq

2458 K
Genx

1525 K
4. tcmeyers
5. kbata
6. Martie
7. Hammerton
8. rrenfrow
9. bneeman
10. plegler
Welcome, Guest. Please login or register.
January 28, 2015, 02:11:41 PM

Login with username, password and session length
Search:     Advanced search
FMWebschool releases more educational FMStudio webinars - check them out here:
http://www.fmwebschool.com/webinars.php
27852 Posts in 6161 Topics by 1525 Members
Latest Member: alkyred
* Home Help Search Calendar Login Register
+  fmwebschool.com
|-+  Recent Posts
Pages: [1] 2 3 ... 10

 1 
 on: January 26, 2015, 09:30:16 PM 
Started by cooldude - Last post by webko
You do two queries, and then combine the data arrays after (assuming they are using the same fields...), and then display the combined set

 2 
 on: January 23, 2015, 01:28:53 PM 
Started by cooldude - Last post by cooldude
Thanks for you help jmrusch.

 3 
 on: January 23, 2015, 01:27:31 PM 
Started by cooldude - Last post by cooldude
Make the size of the found set 1, or do a foreach that only allows 1 loop.


So simple - thanks webco!!!

 4 
 on: January 23, 2015, 01:26:35 PM 
Started by cooldude - Last post by cooldude
Hi all,

I need to do a simple but double query like

1 - find recordset 1
2 - expand found set with additional find

- then have that show as just one combined query to display on web with fmstudio

EX:

1 find this - people from CA
2 ADDITIONAL expand found set people from AZ and last name JONES (what ever)

easy to do in filemaker - how do you do this with fmstudio?


ALSO - maybe I can run a script along with the query ? but what would be the best way to set this up and use this?


Thanks - dave














 5 
 on: January 20, 2015, 04:08:52 PM 
Started by baytonemus - Last post by webko
Can you mail me the details for access back channel, and I'll try from a 3rd party server to connect to the database...

timwebko  gmail

Cheers

Webko

 6 
 on: January 20, 2015, 11:29:48 AM 
Started by baytonemus - Last post by baytonemus
Still no progress on this. I'm posting below a server activity analysis that received from MIVA. Not sure if it will be helpful here, but I'm getting pretty desperate.

Quote
Hi Jay, I wanted to send you some additional information that may help with MacUSA. The following is from a program called 'tcpdump' which is a network packet monitoring program; it is watching the actual network packets between our server and the MacUSA server. This will be useful because it will demonstrate to them that there is no connectivity issue and in fact their server is the one returning the error and error code 802, in xml format.

The two most important blocks of data are the ones timestamped 08:59:42.014871 and 08:59:42.082419. The first is the request from your application to them, including all the arguments and variables. The second is their response, in XML format, where part of it includes the error from them "<error code="802"></error>". This demonstrates that their server is accepting your request, no connection issue, and issuing an error in response. Since the exact times are included, as well as the data you're sending them, use today's date, EST timezone, they should be able to track down what is going on on their server to cause the error.


listening on eth0, link-type EN10MB (Ethernet), capture size 65535 bytes
08:59:41.961179 IP web014.mivamerchant.net.35205 > ns2.macusa.net.http: Flags , seq 2410254587, win 14600, options [mss 1460,nop,nop,sackOK,nop,wscale 7], length 0
E..4e.@.@..M..R22......P..........9.................
08:59:42.014723 IP ns2.macusa.net.http > web014.mivamerchant.net.35205: Flags [S.], seq 572628650, ack 2410254588, win 16384, options [mss 1400,nop,wscale 0,nop,nop,sackOK], length 0
E..47...8.].2.....R2.P.."!........@..A.....x........
08:59:42.014763 IP web014.mivamerchant.net.35205 > ns2.macusa.net.http: Flags [.], ack 1, win 115, length 0
E..(e.@.@..X..R22......P...."!..P..sV^..
08:59:42.014871 IP web014.mivamerchant.net.35205 > ns2.macusa.net.http: Flags [P.], seq 1:720, ack 1, win 115, length 719
E...e.@.@.....R22......P...."!..P..s....POST /fmi/xml/fmresultset.xml HTTP/1.1
Host: hartford.macusa.net
Accept: */*
X-FMI-PE-ExtendedPrivilege: tU+xR2RSsdk=
X-FMI-PE-Authorization: Basic d2VidXNlcjpzZWFyY2hiYXl0b25l
Content-Length: 465
Content-Type: application/x-www-form-urlencoded

-db=SongRef_current&-lay=Combined+Song+Search&-max=10&-find&Scripture+References%3A%3ABibleBook=%2A&Scripture+References%3A%3ABibleBook.op=bw&Scripture+References%3A%3ABibleChapter=%2A&Scripture+References%3A%3ABibleChapter.op=bw&Scripture+References%3A%3ABibleVerse=%2A&Scripture+References%3A%3ABibleVerse.op=bw&SongName=%2A&SongName.op=bw&Topic=%2A&Topic.op=bw&LiturgicalDay=%2A&LiturgicalDay.op=bw&Season=%2A&Season.op=bw&SongType_short=%2A&SongType_short.op=bw
08:59:42.081709 IP ns2.macusa.net.http > web014.mivamerchant.net.35205: Flags [P.], seq 1:414, ack 720, win 64816, length 413
E...7$@.8..T2.....R2.P.."!......P..0.:..HTTP/1.1 200 OK
Connection: close
Date: Thu, 15 Jan 2015 13:59:34 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Date: Thu, 15 Jan 2015 13:59:34 GMT
Server: hartford.macusa.net
MIME-Version: 1.0
Cache-control: no-cache="set-cookie"
Cache-control: must-revalidate
Set-Cookie: fmi-cookie=fmi-cookie; Path=/; Version=1
Content-Type: text/xml; charset=utf-8
Expires: Tue, 03 May 1988 14:40:00 GMT


08:59:42.081750 IP web014.mivamerchant.net.35205 > ns2.macusa.net.http: Flags [.], ack 414, win 123, length 0
E..(e.@.@..V..R22......P...."!.HP..{Q...
08:59:42.082419 IP ns2.macusa.net.http > web014.mivamerchant.net.35205: Flags [P.], seq 414:967, ack 720, win 64816, length 553
E..Q7'@.8...2.....R2.P.."!.H....P..0....<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//EN" "http://hartford.macusa.net:80/fmi/xml/fmresultset.dtd"><fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0"><error code="802"></error><product build="03/02/2011" name="FileMaker Web Publishing Engine" version="11.0.3.302"/><datasource database="" date-format="" layout="" table="" time-format="" timestamp-format="" total-count="0"/><metadata></metadata><resultset count="0" fetch-size="0"></resultset></fmresultset>

I'm not sure why this pasted with all of the strike-through text. Thanks.

 7 
 on: January 16, 2015, 08:16:50 AM 
Started by baytonemus - Last post by baytonemus
One more thing: MacUSA is recommending that I delete the FMStudio-related files on the server and and locally, then reinstall the API using DreamWeaver. I don't even remember how to do that. Plus I'm running DW CS3 on a new MBP and none of the tabs under the Applications menu are showing me what I expect to see this page, so it seems like I don't have things set up properly yet.

I realize that, if I'm going to continue to use DW to edit and maintain my site (even intermittently), I'll need to get the site config straighter out. In the meantime, however, that has nothing to do with the connectivity problem I'm experiencing right now, and I don't have time to waste.

Thanks.

 8 
 on: January 16, 2015, 08:06:06 AM 
Started by baytonemus - Last post by baytonemus
Last night I tried a couple of things, both unsuccessful.

First, I uploaded a bunch of the site files to the server of another organization with which I am associated. Not really allowed, but I figured I could get away with it for a few minutes. That showed me that I would probably need to put the entire site or most of it up to have a successful test. My site has so many SSIs and so much CSS implementation, that I can't really even remember which specific files would need to be uploaded.

Attempting to load the searchBoth.php page just returned a bunch of errors about how "returning as new" was "deprecated" according to certain lines of code in the FM file.

Second, I just re-uploaded the Connections & FileMaker folders plus FileMaker.php and the search page. No change. It seems virtually impossible that the files on the server and my in local folder could have both become corrupted given that I haven't synced.

 9 
 on: January 15, 2015, 09:33:33 PM 
Started by baytonemus - Last post by baytonemus
That's a good idea. Unfortunately, I do not have access to another server for such a test.

 10 
 on: January 15, 2015, 02:45:33 PM 
Started by baytonemus - Last post by webko
802 - Unable to Open File

Given that MacUSA run a hosting service, my personal assumption is that the issue is not on their end... Quick way to test that is to place your forms and required pages onto another web server and see if it works from there.

If it works from the random non-Miva web server, then there is a problem at Miva. If it doesn't then the problem is probably at the MacUSA end

Cheers

Webko

Pages: [1] 2 3 ... 10
Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!