GetStates

Object and Type

Object  : FCApplication

Type     : Method

Prototype

Public Function GetStates(ByVal Country As String) As ADODB.Recordset

Description

This method returns a recordset containing the state_prov records for a given country.

The state_prov and country tables are cached in the FCApplication object, so this method does not cause a database round-trip.

When finished with the returned recordset, you should close the recordset using the .Close method and then set your variable to Nothing or Null. This will release the resources needed for this object.

Parameters

Parameter Name	Required?	Description
Country	Yes	Name of country to get the states for.

Returns

An ADO recordset containing the state_prov records.

Error Codes

Value	Meaning
10011	Country must not be empty.
10012	Invalid Country

Examples

The following example builds a drop-down list of states for the default. The default state is selected.

JavaScript:

<SELECT NAME="States">
<%
var defCountry = FCApp.GetDefaultCountry();
var StateList = FCApp.GetStates(defCountry);
var defState = FCApp.GetDefaultState(defCountry);
while (! StateList.EOF) { %>
  <option
  <% if (StateList("name") == defState) { %>
  selected = true <% } %> >
  <%=StateList("name")%>
  <% StateList.MoveNext; %>
  </option>
<% } %>
</SELECT>

<%
StateList.Close();
StateList = null;
%>