Newbies mactastic Posted December 20, 2004 Newbies Posted December 20, 2004 I am trying to create a new record in a database with FMNew(), but it doesn't seem to be working. I know that the variables have the correct data in them, and the same code used for FMEdit() (plus the -recid parameter) works fine. I've copied the code below: <? include_once("../FX/FX.php"); include_once("server_data.php"); $firstname = $_REQUEST['FIRST_NAME']; $lastname = $_REQUEST['LAST_NAME']; $middleinitial = $_REQUEST['Middle_Initial']; $numids = $_REQUEST['ID_Number']; $birthday = $_REQUEST['Birthday']; $gender = $_REQUEST['Gender']; $ethnicity = $_REQUEST['ETHNICITY']; $localstreet = $_REQUEST['Street_Add']; $localzip = $_REQUEST['Local_City_State_Zip']; $homestreet = $_REQUEST['ADDRESS']; $homecity = $_REQUEST['CITY']; $homestate = $_REQUEST['STATE']; $homezip = $_REQUEST['ZIP']; $localphone = $_REQUEST['Campus_Phone']; $homephone = $_REQUEST['Phone']; $cellphone = $_REQUEST['Cell']; $numIDs = $_REQUEST['NumIDs']; $college = $_REQUEST['COLLEGE']; $gradyear = $_REQUEST['Grad_Year']; $pay = $_REQUEST['Paid_or_Volunteer']; $area = $_REQUEST['Assigned_Area']; $projectcood = $_REQUEST['Project_Coordinator']; $board = $_REQUEST['Board_Member']; $BookQuery2 = new FX($serverIP, $webCompanionPort); $BookQuery2->SetDBData('Student Database.fp5', 'webform'); $BookQuery2->SetDBPassword('4me2know'); $BookQuery2->AddDBParam('FIRST NAME', $firstname); $BookQuery2->AddDBParam('LAST NAME', $lastname); $BookQuery2->AddDBParam('Middle Initial', $middleinitial); $BookQuery2->AddDBParam('ID Number', $numids); $BookQuery2->AddDBParam('Birthday', $birthday); $BookQuery2->AddDBParam('Gender', $gender); $BookQuery2->AddDBParam('ETHNICITY', $ethnicity); $BookQuery2->AddDBParam('Street Add.', $localstreet); $BookQuery2->AddDBParam('Local City State Zip', $localzip); $BookQuery2->AddDBParam('ADDRESS', $homestreet); $BookQuery2->AddDBParam('CITY', $homecity); $BookQuery2->AddDBParam('STATE', $homestate); $BookQuery2->AddDBParam('ZIP', $homezip); $BookQuery2->AddDBParam('Campus Phone', $localphone); $BookQuery2->AddDBParam('Phone #', $homephone); $BookQuery2->AddDBParam('Cell Phone', $cellphone); $BookQuery2->AddDBParam('Num of IDs', $numIDs); $BookQuery2->AddDBParam('COLLEGE', $college); $BookQuery2->AddDBParam('Grad Year', $gradyear); $BookQuery2->AddDBParam('Paid or Volunteer', $pay); $BookQuery2->AddDBParam('Assigned Area', $area); $BookQuery2->AddDBParam('Project Coordinator', $projectcood); $BookQuery2->AddDBParam('Board Member', $board); $BookData2 = $BookQuery2->FMNew(); $currentKey2 = key($BookData2['data']); ?>
Recommended Posts
This topic is 7380 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now